Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum if -- Sum_range across multiple columns
I have a list of names in the first column with corresponding numbers across
subesquent columns: A B C D NAME 1 1 5 7 NAME 2 8 2 9 NAME 3 6 4 10 What I want is a sumif formula on a separate sheet to total columns b thru d for each person based on the name in column a. This is the forumla I have (the name of the sheet is Jan 8 - 20): =SUMIF('Jan 8 - 20'!$A$5:$A$513,A1,'Jan 8 - 20'!$B$1:$D$3) The problem is that the formula is only adding the numbers in column b and none of the rest of the columns. I'm not sure what I'm doing wrong here. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF - Sum_Range is misleading | Excel Worksheet Functions | |||
SUMIF with the Sum_range across several colums | Excel Worksheet Functions | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
SUMIF with multi-column sum_range | Excel Worksheet Functions |