View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
confused confused is offline
external usenet poster
 
Posts: 193
Default 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