Please help

[_Landon]

Hello,

I’m having some trouble with a formula solution that I am stuck on.

I need to count a simple tally, if a row has been marked “MC” AND a value (number) has been entered in any combination to P,Q, or R then count as 1.

My formula is attached, and the issue is the value has to be numerically 0 for it to function. Currently it will count a value if “MC” is marked on the row and no numbers have been inputted. I don’t want zeros all over the sheet, I want the sheet to remain blank unless info has been added.

I would greatly appreciate any other ideas or ways to simply count.
Thank you!!

 

[_Landon]

This may be helpful, as it shows you how you can do "OR" like conditions in COUNTIFS formulas.

Excel COUNTIF and COUNTIFS with OR logic

Learn how to use Excel COUNTIF and COUNTIFS functions to handle multiple conditions with OR logic.

www.ablebits.com

Thank you Joe.

I ended up making a hidden table combining the data first. And then using =COUNTIFS to pull from.

A little extra work, but it solved my problem. Thank you again for your help!

 

[Joe4]

You are welcome!
Glad I was able to help!