Count if condition for multiple columns and dates

[ismailzkhan]

Dear Techies,

Please check attached file. I'm looking to get results with multiple conditions like Resource Names, status, start and end date.

Thanks in Advance

Regards,
Ismail Khan

 

[Somendra Misra]

Hi,

See the attached file.

Regards,

 

[iferror]

Even though i would DEFINITELY go with Somedra' formula, just for the sake of completeness i'm going to supply an alternative here

(works on Excel >=2007)
paste this formula in G9 and copy down/across
=COUNTIFS($C$6:$C$24;G$8;$B$6:$B$24;$F9;$A$6:$A$24;">"&$G$5;$A$6:$A$24;"<"&$H$5)

 

[ismailzkhan]

Hi,

Thanks Somendra and iferror. You guyz rocks.

Rgds,
Ismail Khan

 

[Somendra Misra]

Welcome back anytime.

Regards,