Sep 01 2021 04:02 PM
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.
Sep 01 2021 06:37 PM
SolutionSep 01 2021 06:37 PM
SolutionFor "Eng":
=COUNTIFS(B2:B20,"Eng",A2:A20,"<>")+COUNTIFS(B2:B20,"Eng",C2:C20,"<>")