SOLVED

# Formula Assistance

Occasional Contributor

# Formula Assistance

Hello, Microsoft Community!

I am in need of formula help once again. I want to COUNT the number of entries in two separate columns (A and C) but only if they meet certain criteria in a third column (B).

Q: What is the total number of services provided to those who speak English AND what is the total number of services provided to those who speak Spanish? The sum total of services equals 20.

Example:

 A B C D E F Services A Language Services B Column3 CS Eng - - - CS Eng - - - MA Eng - - - MA Eng - - - MA Eng - - - MA Eng - - - PN Eng - - - PN Eng - - - PN Eng - PT Eng A - PO C Eng B - AC - MA Sp - - - MA Sp - - - MA Sp - - - MA Sp - - - PC Sp - PC Sp - PC Sp - Sp C - - Total Services: 20 Total Eng: Total Sp:

Thank you for helping me with the project with skills beyond my abilities.

2 Replies
best response confirmed by MMHiggins (Occasional Contributor)
Solution

# Re: Formula Assistance

For "Eng":

``=COUNTIFS(B2:B20,"Eng",A2:A20,"<>")+COUNTIFS(B2:B20,"Eng",C2:C20,"<>")``

# Re: Formula Assistance

Thank you, Detlef Lewin!