Hello Community,
I am currently working on a report where I have sets of data with 0 values that I cannot remove from the table. In order for me to count the items with more than 1 value I uses this formula =COUNTIFS(A1:A10,"Project",B1:B2,"OPPID",C1:C2,"January",D1:D2,"2016") but the problem right now is the formula is also counting items with 0 values.
I there any formula that I could use where it will not count items with 0 values?
Many thanks in advance
Last edited by Ex-xcel; 09-29-2016 at 12:19 AM. Reason: Problem Solved
Hi -
Can you post a sample spreadsheet (not an image) with any sensitive data removed so we can see specifically what the problem is? Also, provide a couple of examples with the result you expect.
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
Try
Formula:
Please Login or Register to view this content.
A1:A10?
Hello - please see attached sample table. Thanks
In G4 try
Formula:Please Login or Register to view this content.
Last edited by José Augusto; 09-28-2016 at 11:55 AM. Reason: Address of January and Year
Hi
g4=COUNTIFS($B$4:$B$23,F4,$C$4:$C$23,$F$3,$D$4:$D$23,">"&0) copy down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks