Adding up columns for speciic rows

  • Thread starter Thread starter confused
  • Start date Start date
C

confused

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
where:
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
 
=SUMPRODUCT((A1:A10="Build")*(B1:B10="Business")*C1:E10)

--
---
HTH

Bob


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