• Announcements

    • Daphne

      Winners Announcement   09/18/2017

      htmlentities(

      Awesome! You guys just made around 48000 shares in our #AcrobatAlternative Event!!! Thank you so much for joining! Congratulations to our big prizes winners: @Colleen and @Anne Bastien !!! Click here to know more. 

      )
    • Daphne

      Official Release of version 6.3.0   09/19/2017

      htmlentities(

      We have released the new version 6.3.0 for both of Windows and Mac version program PDFelement 6 Professional! The Windows version program supports XFA files, PDF attachments and multi-tiled screen,etc. Start your experience now: https://pdf.wondershare.com/

      )
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