| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup and sum
Hi there,
Is there a way to sum data with a vlookup, as follows: Style Jan Feb Mar Apr ... 002 100 100 100 100 ... 003 150 150 150 150 ... In another sheet, I want to sum year-to-date info by style. sum of vlookup(A2,A2:I3,1,0) to vlookup(A2,A2:I3,3,0) Thank you and regards, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup and sum
Why not just do
=SUM(B2:I2) why do you need the lookup? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "CyberFox" wrote in message ... Hi there, Is there a way to sum data with a vlookup, as follows: Style Jan Feb Mar Apr ... 002 100 100 100 100 ... 003 150 150 150 150 ... In another sheet, I want to sum year-to-date info by style. sum of vlookup(A2,A2:I3,1,0) to vlookup(A2,A2:I3,3,0) Thank you and regards, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup and sum
Cos I'm compiling financial info, and need to sum based on the month chosen...
"Bob Phillips" wrote: Why not just do =SUM(B2:I2) why do you need the lookup? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "CyberFox" wrote in message ... Hi there, Is there a way to sum data with a vlookup, as follows: Style Jan Feb Mar Apr ... 002 100 100 100 100 ... 003 150 150 150 150 ... In another sheet, I want to sum year-to-date info by style. sum of vlookup(A2,A2:I3,1,0) to vlookup(A2,A2:I3,3,0) Thank you and regards, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup and sum
You can just use
=SUM(OFFSET(B2,,,1,3)) where 3 is the month number -- HTH Bob Phillips (remove nothere from email address if mailing direct) "CyberFox" wrote in message ... Cos I'm compiling financial info, and need to sum based on the month chosen... "Bob Phillips" wrote: Why not just do =SUM(B2:I2) why do you need the lookup? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "CyberFox" wrote in message ... Hi there, Is there a way to sum data with a vlookup, as follows: Style Jan Feb Mar Apr ... 002 100 100 100 100 ... 003 150 150 150 150 ... In another sheet, I want to sum year-to-date info by style. sum of vlookup(A2,A2:I3,1,0) to vlookup(A2,A2:I3,3,0) Thank you and regards, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
