Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup question
Hello,
I have a spreadsheet. that has 2 columns A and B In the A column there are numbers. and in the B column there are people initials. the people can be in multiple columns can i use vlookup to add up all the numbers by a persons initals? so: A B 4 xx 5 xx 2 yy 8 xx 7 yy I see I could do somthing like this but it is an error = VLOOKUP("xx", A11:B14, 1, FALSE) can anyone help? thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup question
If you want to "add up all the numbers by a person's initials", don't
use VLOOKUP at all: =SUMIF(B4:B7,"xx",A4:A7) Or, to get a list of everyone's sums, use a Pivot Table instead. In article , "greg" wrote: Hello, I have a spreadsheet. that has 2 columns A and B In the A column there are numbers. and in the B column there are people initials. the people can be in multiple columns can i use vlookup to add up all the numbers by a persons initals? so: A B 4 xx 5 xx 2 yy 8 xx 7 yy I see I could do somthing like this but it is an error = VLOOKUP("xx", A11:B14, 1, FALSE) can anyone help? thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup question
Try this:
= SUMIF(B1:B10,"xx",A1:A10) "greg" wrote in message ... Hello, I have a spreadsheet. that has 2 columns A and B In the A column there are numbers. and in the B column there are people initials. the people can be in multiple columns can i use vlookup to add up all the numbers by a persons initals? so: A B 4 xx 5 xx 2 yy 8 xx 7 yy I see I could do somthing like this but it is an error = VLOOKUP("xx", A11:B14, 1, FALSE) can anyone help? thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup question
WOW....
ok. that worked. thought it would be the vlookup thanks "JE McGimpsey" wrote in message ... If you want to "add up all the numbers by a person's initials", don't use VLOOKUP at all: =SUMIF(B4:B7,"xx",A4:A7) Or, to get a list of everyone's sums, use a Pivot Table instead. In article , "greg" wrote: Hello, I have a spreadsheet. that has 2 columns A and B In the A column there are numbers. and in the B column there are people initials. the people can be in multiple columns can i use vlookup to add up all the numbers by a persons initals? so: A B 4 xx 5 xx 2 yy 8 xx 7 yy I see I could do somthing like this but it is an error = VLOOKUP("xx", A11:B14, 1, FALSE) can anyone help? thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup question
On May 11, 10:34 am, "greg" wrote:
Hello, I have a spreadsheet. that has 2 columns A and B In the A column there are numbers. and in the B column there are people initials. the people can be in multiple columns can i use vlookup to add up all the numbers by a persons initals? so: A B 4 xx 5 xx 2 yy 8 xx 7 yy I see I could do somthing like this but it is an error = VLOOKUP("xx", A11:B14, 1, FALSE) can anyone help? thanks I'd suggest doing this. Either below all the data, or to the side, you'll need two columns. In one column, type in the names. In the second column, you want to use the SUMIF formula. Here's my assumptions - the numbers for each name are in cells A2 to A12 and the names are in cells B2 to B12. In cells A15 and down, you place all the names you want to sum up. Next to the names, starting in cell B15, type this formula: =sumif($B$2:$B$12,A15,$A$2:$A$12) Hope this helps. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Question | Excel Worksheet Functions | |||
VLOOKUP question | Excel Programming | |||
VLOOKUP question | Excel Worksheet Functions | |||
vlookup question | Excel Programming | |||
Vlookup question | Excel Programming |