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
|