COUNTIFS - Blank cells

Hi,

I'm looking for a solution to my COUNTIFS formula. Right now it has x3 Criteria Range but I need a 4th, the first 2 Criteria Range are constant but the 3rd or 4th should be variable. I'd like the formula to say... COUNTIFS, Criteria Range 1, 2 & 3 IF Criteria Range 4 is blank, IF Criteria Range 4 is not blank then COUNTIFS, Criteria Range 1, 2 & 4.

Is this achievable?

Thanks.

what is criteria 4?

Originally Posted by belinda200

what is criteria 4?

It’s a date, criteria 3 and 4 are both dates.

Originally Posted by belinda200

what is criteria 4?

To be precise, it’s a month number rather than a date.

You don't say, but I'm assuming the Date you're referring to for Criteria 4 is "Month" in Table4.

Can you just add another column to Table4 (called "Month3", say), and put in the formula:
=IF([@MONTH2]="",[MONTH],[@MONTH2])
and then H20, you could change your reference to "Month2" to "Month3"
=COUNTIFS(Table4[WHERE],Table5[[#Headers],[WEBSITE]],Table4[STATUS],[@STATUS],Table4[Month3],[@MONTH])

Originally Posted by Gregb11

You don't say, but I'm assuming the Date you're referring to for Criteria 4 is "Month" in Table4.

Can you just add another column to Table4 (called "Month3", say), and put in the formula:
=IF([@MONTH2]="",[MONTH],[@MONTH2])
and then H20, you could change your reference to "Month2" to "Month3"
=COUNTIFS(Table4[WHERE],Table5[[#Headers],[WEBSITE]],Table4[STATUS],[@STATUS],Table4[Month3],[@MONTH])

So simple... thank you very much.