Count from two columns

Hello,

I have tried for a time to find a formular that will give the counts I need.

I have Residential inspections and Commercial inspections. I need a formular in cells M14, M15. M16, M17, M18 that will give me a count of Commercial inspections with perspective results. ( Pass, Re-Inspect, Yellow Tag, Red Tag/Fee, Stop Work)

I am using a Code columns to distinguish Commercial from Residential.

Example Commercial Renovation = CR
Commercial Roof Replacement = CRR

I hope I explained this well enough.

see attachment.

EDW

Not sure if my attachment made it.

How about in M14 dragged down

Formula:

Please Login or Register  to view this content.

m14 and copy down
=COUNTIFS(F:F,L14,B:B,"C*")+COUNTIFS(F:F,L14,B:B,"nc")

you would be much better chosing your codes from data valuation lists as your spreadsheet is asking for trailing blanks to creep in

Thanks. This worked perfect.

Not sure which of us you're talking to, but glad to help & thanks for the feedback.