| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding values across a row based on a corresponding column value
This is probably simple, but I cannot figure it out. Question refers to
table below: Column A Column B Column C Column D ============================= Julie 600 200 300 Scott 100 200 400 Tom 132132 111 4000 Craig 100 1000 100 Question: I'm trying to help a colleague calculate the value across a row for Columns B-D when a value in Column A matches the criteria. For example, I want Excel to calculate the totals for Scott. The result should be 700. The formula I'm using is this: =SUMIF(A2:A5,"Scott",B2:D5). I know there's something wrong with my Sum_range, but I cannot figure it out. Any help is appreciated. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| Adding values from 1 col based on value in diff col | Excel Discussion (Misc queries) | |||
| adding values based on criteria | Excel Worksheet Functions | |||
| Adding Values Based on a Separate Column | Excel Discussion (Misc queries) | |||
Threaded Mode
