Help With Formula

[meppwc]

Can someone assist me with a formula?

Solve for cell E2.
If the BldgCode is “A” and the LocationCode is “CC" then count how many instances of “Model A” are found in column B.

BldgCode data is in column D, LocationCode data is in column C, and “Model A” value can be found anywhere in column B.

 

[Aladin Akyurek]

Looks like

=COUNTIFS(B:B,"Model A",C:C,"CC",D:D,"A")

 

[meppwc]

Thank you Aladin

 

[Aladin Akyurek]

Thank you Aladin

You are welcome.