• Announcements

    • Daphne

      PE Points Program!   09/26/2017

      htmlentities(

      We are excited to announce that we are launching our brand new PE Points Program. Read more here for detailed rules and get ready to win some cool prizes!

      )
    • Daphne

      Happy Thanksgiving!   11/13/2017

      htmlentities(

      We are honored to sponsor the well designed Thanksgiving Card for free to people who gives their thanks in social media. Join Us to give your thanks to the one you love!

      )
Dicki Smits

count rows where cell "one" has condition?

7 posts in this topic

I want to create an table where people can fill in an catagory  an article and a price.

At the end of the table i will count the total price of 1 category.

 

Is that possible with PDF Elements ?

 

so i want to count with conditions.

 

In Excel i use SUMIF, but is that possible with PE?

 

Hope to hear Yes :-) But how do i do that?

 

thanks for your help 

 

 

Share this post


Link to post
Share on other sites

Hi Dicki, 

 

Thanks for reaching out! 

Yes, you are able to count with conditions. I have attached an example with a budgeting table: 

 

1) Insert all the text boxes under "form". 

Screen Shot 2017-08-03 at 2.08.40 PM.png

 

2) Double click on the box that you want to calculate the total amount from. A window should pop up. Select the "calculate" tab, then the second radio button option, which will let you pick what sort of calculations you want the box to do. Then, click the "pick" button. 

Screen Shot 2017-08-03 at 2.08.49 PM.png

 

3) A second window will pop up, and you can select all the text boxes that you want to include in the calculation.

Screen Shot 2017-08-03 at 2.08.59 PM.png

 

4) Input numbers in the other boxes and test it out!

Screen Shot 2017-08-03 at 2.09.14 PM.png

 

Hope this helps, let me know if you have any other questions! 

 

Best, 
Rebecca

Share this post


Link to post
Share on other sites

Thanks for your quick reply. And yes this option i already found.

But that is the SUM formule

I was looking for SUMIF formule.

 

That means that i can count all rows where in the collum "a" the value is: "other"

In case of the example the total contributions of "other" should be: 22

That is the formule where i am looking for.

Please tell me that that is possible with PE.

 

thanks anyway

Share this post


Link to post
Share on other sites

Look in attatchment what i want to achief:

 

I want to count all the money in collum "Kas-Bij" where in collum  BC is a specific code.

So i can find the total of that specific code.

 

Hope this is clear.

 

Thanks

 

boekhoudstaat.pdf

Share this post


Link to post
Share on other sites

Hi Dicki,

 

I am sorry that our program does not support SUMIF formula currently, we will keep improving more features.

 

Thanks for your feedback.

Share this post


Link to post
Share on other sites

thanks for your clear answer. I look forward to furter features.

 

thansk

Share this post


Link to post
Share on other sites

Hi Dicki,

 

Thanks for your feedback and suggestion. 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now