Countifs formula with multiple criteria

[awhite1]

I need a formula that will count each type of inspection that each inspector completes when a date is put in collum G. Right now, I have a formula that only counts the amount of each type of inspection is done by each inspector but it doesn't take into account when they complete it. The N27 in my formula refers to a table with an inspector's name in that cell. Thanks for your help.

 

[bebo021999]

" it doesn't take into account when they complete it"
what do you mean with this?
Is result incorrect?

 

[awhite1]

The result is correct for counting the amount of each type of inspection that is done by each inspector but I need it to count the amount of each type of inspection that is done by each inspector when a date is put in the column for inspection complete.

 

[Sergius]

Add a check for termination
=IF(G27<>"";your count formula;"")

 

[RoryA]

I think you need to add:

$G$2:$G$250,">0"

as an additional criterion to your existing formula.

 

[awhite1]

I think you need to add:

$G$2:$G$250,">0"

as an additional criterion to your existing formula.

That worked perfectly, thank you. I had something similar but it was just a little off.