hi i have a question about countif. i have a list of employess who i need to count each month. i need a way i can say count if >0 for month = Oct. each employee has a summary of there work for a month in a list going down.
example
___John
Jan__0
Feb__19
Mar__50
___Bob
Jan__4
Feb__56
Mar__12
Right now i have a way i am summing up the total work for all the employees
"=SUMPRODUCT(B21:B512,--(A21:A512=A4))" <------'A4=Jan in the formula'
How could i change this to reflect count the employees and not sum the total? The idea is a need to know how many employees had a number greater then 0 for the month of Oct.
Last edited by johnjohn5; 10-30-2008 at 02:30 PM.
Perhaps this...
Does that help?=SUMPRODUCT((A21:A512=A4)*(B21:B512>0))
Thanks that worked like a charm.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks