Spikenaylor
Board Regular
- Joined
- Apr 14, 2013
- Messages
- 115
- Office Version
- 365
- Platform
- Windows
I need to count cells in row Z that match the criteria in Row A. This means I can easliy change the criteria (Row A) going forwards and not have to change the formula
My current Row Z contains Y and N, my current criteria is to count cells that are Y. however the way the crtieria has been written may change and soem of the Criteria may change to N, so I would have to count the Y and N. If my formula was to count cells in Row Z that each row matches the criteria value in Row A, then this would be some future proofing
at the moment my formula is COUNTIF(Z11:Z12,"Y")+(COUNTIF(Z14,"N"))
If I could get the formula to count Row Z where each row matched Row A, Then the Criteria could change at some date in the future, but the formulas would not need changing
hope this makes sense
Regards
My current Row Z contains Y and N, my current criteria is to count cells that are Y. however the way the crtieria has been written may change and soem of the Criteria may change to N, so I would have to count the Y and N. If my formula was to count cells in Row Z that each row matches the criteria value in Row A, then this would be some future proofing
at the moment my formula is COUNTIF(Z11:Z12,"Y")+(COUNTIF(Z14,"N"))
Row A - Criteria | Row Z - actual Result |
Y | Y |
Y | N |
If I could get the formula to count Row Z where each row matched Row A, Then the Criteria could change at some date in the future, but the formulas would not need changing
hope this makes sense
Regards