bluenova8413
New Member
- Joined
- Sep 10, 2019
- Messages
- 2
Hello - I'm trying to write a COUNTIFS formula that includes multiple cell references as criteria. However, if one or more of these cells is left blank, I would like the COUNTIFS criteria to be excluded.
In my example sheet - the formula in G13 includes criteria referenced G6:G8. But since I have left G6 blank, I just want the formula to narrow the count by the criteria in G7 & G8.
Is there a way to do this? Thank you!
In my example sheet - the formula in G13 includes criteria referenced G6:G8. But since I have left G6 blank, I just want the formula to narrow the count by the criteria in G7 & G8.
Is there a way to do this? Thank you!