Hi forum,
On the UMMS BC Labour Input, I have certain cells which are conditionally formatted.
Is there a way to count those cells which do not have a value in the cell?
So for example on row 2 from columns D to AP there are 9 cells which are conditionally formatted and out of those 9, 1 has a value of 0.
What forumula will return the number 8 for the other formatted blank cells?
Thanks in advance
Andrew
You can't use CF applied in formula.
You have to use underlying logic/calculation in your formula.
Ex:
=COUNTIFS('UMMS BC Labour Matrix'!C2:AO2,1,'UMMS BC Labour Input'!D2:AP2,"=")
Edit: Woops. Formula should be...
=COUNTIFS('UMMS BC Labour Matrix'!C2:AO2,1)-COUNTIFS(D2:AP2,"<>")
Last edited by CK76; 07-07-2020 at 10:16 AM.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
You will need to base the count on the source sheet - you can't count formatting.
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.
Many thanks CK76, excellent work
Hi CK76, are you sure the edit is correct? The first one appears to give the right answerOriginally Posted by CK76
Funny - I seem not to exist.
Edit is correct. First one will give wrong answer.
See attached. I've assumed that you won't have values in cells where CF evaluates to false.
Sorry AliGW, I hadnt seen your response when I replied to CK
No worries - I was just having an existential crisis.
Thankyou both
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks