Hi all,
I am trying to work out how to count the number of times 0 is entered for specific cells as shown in the attachment but all my efforts keep returning error's.
Can anyone offer some advice on what i am doing wrong please?
Thank you
Hi all,
I am trying to work out how to count the number of times 0 is entered for specific cells as shown in the attachment but all my efforts keep returning error's.
Can anyone offer some advice on what i am doing wrong please?
Thank you
Last edited by dead*; 12-12-2015 at 11:13 AM.
In A13 copied across and down:
=COUNTIFS($D$12:$U$12,A$12,$D13:$U13,0)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks for the reputation - I am glad it worked for you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks