Thread
:
Sum Multiple Criteria
View Single Post
#
8
Posted to microsoft.public.excel.worksheet.functions
JCS
external usenet poster
Posts: 93
Sum Multiple Criteria
Many thannks Don. Your help is greatly appreciated.
John
"Don Guillett" wrote:
=SUMPRODUCT((C5:C18={"taurus","fusion"})*D5:D18)
Need NOT be array entered
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"JCS" wrote in message
...
Hello Everyone,
I have been try to learn how to use the SUM function with multiple
criteria.
I have run into a road block with my experimentation. By the way, I am
using Excel 2003 SP3. My data looks like the following:
city Mfr model volume
dearborn ford taurus 10
troy ford fusion 20
shelby gm lacrosse 10
warren chrysler sebring 10
dearborn gm camaro 30
detroit ford fusion 40
shelby chrysler magnum 20
warren chrysler avenger 40
troy chrysler avenger 20
detroit gm lacrosse 50
detroit gm impala 30
warren ford fusion 40
troy chrysler avenger 20
detroit ford taurus 10
The formula I am having a problem with is:
{=SUM(($C$5:$C$18="taurus")+($C$5:$C$18="fusion")+ ($D$5:$D$18))}
The Sumprduct yields 120 as the answer which is correct but the formula
above yields 355 as the answer. What am I missing?
Thanx in advance,
John
.
Reply With Quote
JCS
View Public Profile
Find all posts by JCS