Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of Cells if Row Contains a Specific Variable
Hi Everyone. I've found tons of help in these forums in the past, and
am hoping I can again. I've put together a spreadsheet for sales tracking, and need to sum a group of multiple cells in multiple rows, based on a value in a specific column. An example: ColumnA ColumnB ColumnC ColumnD Row1 John 2 3 Row2 Edward 3 5 Row3 Frank 1 2 Row4 John 2 0 Row5 Frank 0 5 I need a formula that will sum the totals from columns B and C, for all rows that contain "John". Once complete, the above example would look something like this: ColumnA ColumnB ColumnC ColumnD Row1 John 2 3 7 Row2 Edward 3 5 8 Row3 Frank 2 2 9 Row4 John 2 0 7 Row5 Frank 0 5 9 I've tried various iterations of formulas using =COUNTIF, =SUMPRODUCT, =SUBTOTAL - but so far haven't found a solution. Any suggestions or hints would be greatly appreciated. Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of Cells if Row Contains a Specific Variable
A thousand thanks. That works perfectly.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
how to format only specific characters or numbers within each cellwithin a range of cells | Excel Discussion (Misc queries) | |||
how to format only a specific character or number in each cell withina range of cells | Excel Worksheet Functions | |||
Locate and delete specific cells | Excel Discussion (Misc queries) |