Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
adding more columns/rows | Excel Discussion (Misc queries) | |||
Adding rows/columns to linked file | Links and Linking in Excel | |||
adding specifics columns and rows | Excel Worksheet Functions | |||
Disable Adding & Deleting Rows/Columns | Excel Discussion (Misc queries) | |||
Disable Adding or Deleting Rows and Columns | Excel Discussion (Misc queries) |