G
Guest
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?
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?