help nesting OR statement into COUNTIFS statement

I have 5 total criteria for a COUNTIFS statement, but the first 3 criteria are true regardless:

Formula:

=COUNTIFS(RangeA,CriteriaA,RangeFromDate,">="&$B$2,RangeToDate,"<="&$B$3)

Next I need an OR statement that will return my count if, for example, RangeB with criteriaB is true - OR - if RangeC with CriteriaC either one is true.

Of course, if my data meets both Range/Criteria B and C, then it will only count once, right?

Any help is greatly appreciated, as always!

-HeyInKy

Originally Posted by Tony Valko

Try this...

=SUMPRODUCT(--(RangeA=CriteriaA),--(RangeFromDate>=$B$2),--(RangeToDate<=$B$3),SIGN((RangeB=CriteriaB)+(RangeC=CriteriaC)))

Ok, a follow-up request came in to add one more "OR" criteria... would I just add the new condition to the SIGN function with another "+" such as:

Formula:

=SUMPRODUCT(--(RangeA=CriteriaA),--(RangeFromDate>=$B$2),--(RangeToDate<=$B$3),SIGN((RangeB=CriteriaB)+(RangeC=CriteriaC)+(Range D=RangeD)))

...and would that function as an "OR" for either criteria B, C or D?

Thanks!

Yepp... Excellent. Bravo!

Yes, I did. Thanks.