If & Countifs

[Darth_Williams]

Good morning all,

Can an IF statement be used with a COUNTIFS?

I currently have the following formula that works a treat =COUNTIFS(Range,">="&Start Date, Range, "<="&End Date) This counts everything which falls in a certain date range, but what I need is to incorporate an IF statement which basically says that if another range for that row equals Yes then perform the above, otherwise don't count it.

Any help would be gratefully received.

Thanks

 

[Marcelo Branco]

Try

=COUNTIFS(Range,">="&Start Date, Range, "<="&End Date, AnotherRange,"Yes")

Range and AnotherRange must have same size

M.

 

[Darth_Williams]

Thank you Marcelo, that worked a treat. That'll teach me for over thinking it

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.