Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Good afternoon,
I am trying to assist somebody at work. I would like to ask if there is a way to set a formula in a totals cell at the bottom or a spreadsheet (for example) where for every cell in Column A that contains a certain ID, their corresponding values in column B are summed. For instance if A2 A3 AND A11 contain a specific ID, then a 'totals' cell would add B2, B3 AND B11. I would like to use an IF statement or something for example: (SUM B cells where A cells=ID). What syntax would I use for this? Thanks. Cordially, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional criteria in DSUM | Excel Discussion (Misc queries) | |||
Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
Max value that meets a criteria | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |