Sum Multiple Criteria or DcountA

[rjenkins]

Can Someone help out with this? I am trying to use the Sum formula t
count multiple criteria. I want to COUNT how many times that "Joh
Doe" with a Grade of "B" appear in the list.

Here is what I have tried that doesn't seem to work thus far

=SUM((C1:C10="John Doe")*(D110="G")) ctr+shift+enter

I get an #Value? error message with this one.

I also tried this dcounta formula although I would prefer to use th
sum formula, b/c it will work better for me with what I am ultimatel
doing here.

=DCOUNTA(DataTable,"Name",O2:O3)*DCOUNTA(DataTable,"Grade",G)

The criteria here (O2:O3) match the Column headings and value that I a
searching for. Again - I would prefer not to use this, but if the su
formula array won't work then I am open to it.

A B C D
1 Account Name Total Employees Name Grade
2 XYZ Company 70 John Doe B
3 XYZ Company 70 Suzi Q B
4 XYZ Company 70 Fred Jones B
5 ABC Company 60 John Doe C
6 ABC Company 60 Jack Black C
7 ART Institute 50 John Doe B
8 ART Institute 50 Suzi Q B
9 Metal Company 110 Suzi Q C
10 Metal Company 110 Wilma Rubble C


Thanks for your Help.

-Rya

 

[JE McGimpsey]

One way:

=SUMPRODUCT(--(C1:C10="John Doe"),--(D110="G"))

 

[rjenkins]

Thanks for your reply!!

I plugged that formula in and got this error message: #N/A

Any thoughts

 

[JE McGimpsey]

Remove any #N/A values from the ranges in the SUMPRODUCT formula, as
they'll get passed through.