Countif with Then & If statements

[Cbrez]

Hello,

I am trying to input a formula to count the number of fields on the Trim tab in column K with the word 'Ongoing' if the following criteria is true for each Subsystem:

Column A has 'B Check'
Column C has 'E'

I want the total number of fields added and inputted in Column J on the Summary tab.

I have tried the following formulas:

=IF((Trim!$B2:$B2000="069-005")*AND(Trim!$C2:$C2000="E"),(COUNTIF(Trim!$K2:$K2000,"Outgoing")))



=SUMPRODUCT(--(Trim!$B$2:$B$2000="173-001")*AND--(Trim!$C$2:$C$2000="E")*AND--(Trim!$A$2:$A$2000="B Check")*AND--(Trim!$K$2:$K$2000="Ongoing"))

Thank you!

[Vikas_Gautam]

Try this..

Please Login or Register  to view this content.

[Cbrez]

Works great!! Thank you very much!!

[Vikas_Gautam]

However you can try this as well..

Please Login or Register  to view this content.