Count number of cells associated with value in separate column

Hey everyone,

Can anyone help me out with my workbook? turnaround.xlsx

C5: Count the number of cells in column G that are Greater than 48 hrs IF the corresponding value in column D IS Associate
D5: Count the number of cells in column G that are Greater than 48 hrs IF the corresponding value in column D IS Admin'

C5: Count the number of cells in column E IF the corresponding value in column D IS Associate AND the corresponding value in column E is not blank
D5: Count the number of cells in column E IF the corresponding value in column D IS Admin AND the corresponding value in column E is not blank

I really appreciate all your help!

Originally Posted by FDibbins

have you tried modifying the countifs() you have already used?

C5=COUNTIFS(G:G, ">48:00",A:A,"associate" )
and =COUNTIFS(G:G,">48:00",A:A,"associate",E:E,">0")

and I think you have your references mixed up in your post above?

Thanks for your help there. Those formulas work in finding one part of my request.

However, I would also like to find the total number of "associates" IF there is data in column E. Thanks in advance for your help.