Counting date ranges that have a certain criteria

[TaleahaD]

HELP!!

I have a training matrix which i need to get monthly total of how many people have done what and from which company.... but the data is all in dates of when the completed it
I have tried countifs and can't seem to get it to work.....

Please Login or Register  to view this content.

I need to have a formula that will count Column C if it =TI or CONT but then count how many of them have completed First Aid

tried -countifs(C239:C282, "TI",BD239:BD282, <>Today)
and a range of others... totally at a loss!!!!!!

[icestationzbra]

try:

=SUM(COUNTIFS(C239:C282,{"ti","cont"},BD239:BD282,"<="&TODAY()))

[ajm123456789]

what would column BD show if they havent completed first aid?

[TaleahaD]

what would column BD show if they havent completed first aid?

it is blank....

[TaleahaD]

this works... but if i put the array in it doesn't

=IF(C2="TFE",BD1,"0")