Adding up columns for speciic rows
 

Hi,

I'm struggling to write formula to add up columns for specific rows and was
wondering if anyone could help?

I want to add up the numbers in column C, D and E but only for those rows
whe
Column A = "Build"
Column B = "Business"

So in the example spreadhseet below, i would want my formula to calculate
the answer 50 (adding columns c, d and e for the first and second rows)

column A coumn b Column c column D column E
Build Business 10 15 15
Build Business 5 0 5
Design Business 5 15 10
Build Tech 4 3 7

Any help is aprreciated

any thanks

Adding up columns for speciic rows
 

=SUMPRODUCT((A1:A10="Build")*(B1:B10="Business")*C 1:E10)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"confused" wrote in message
...
Hi,

I'm struggling to write formula to add up columns for specific rows and
was
wondering if anyone could help?

I want to add up the numbers in column C, D and E but only for those rows
whe
Column A = "Build"
Column B = "Business"

So in the example spreadhseet below, i would want my formula to calculate
the answer 50 (adding columns c, d and e for the first and second rows)

column A coumn b Column c column D column E
Build Business 10 15 15
Build Business 5 0 5
Design Business 5 15 10
Build Tech 4 3 7

Any help is aprreciated

any thanks