Sum Multiple columns within Vlookup

C

Clastir

Hi, i have ben trying to sum mutiple columns in one Vlookup. But its no
working. Does anyone know a way of doing this
 
P

pauluk

i would use the following to sum varible columes

=SUM(A1:A100,C1:C100)

OR IF YOU ARE DOING ROWS

=SUM(A1:D1,A5:D5)

Vlookup is used to look at the value to the left of the cell then reur
a value in that cell.

i.e. if youse codes say ex means excel file

you place the code in colum a then the formula looks this up in a lis
and places excel file in colum
 
J

Jason Morin

VLOOKUP is not intended for summing. It's purpose to find
a value in a column and return a corresponding value of
the same row at n columns to the right.

Re-state what you are trying to accomplish and include a
small sample of data (don't attach a file - just type it
in the post).

HTH
Jason
Atlanta, GA
 
A

Alan Beban

Post a small sample of your ddata, and state what you're trying to
accomplish with that sample.

Alan Beban
 
C

Clastir

I have one sheet that the data changes in ( its a report dump from
data base ) I have another Sheet which i use to collect the data
need. The VLookup is used becuse the report does not always contai
the same rows in the same order ( TXT doc with tab delimiters)
The look up keys on a UI in column one and reads data acrross the row
i require. In some cases i require data to be summed in one row fro
more than one colum ...like " =(VLOOKUP($A9,'[Weekly Stat 15.xls]No
Ready Time'!$1:$65536,10,FALSE))+(VLOOKUP($A9,'[Weekly Stat 16.xls]No
Ready Time'!$1:$65536,15,FALSE)) " and what i was woindering if i coul
do is " =(VLOOKUP($A9,'[Weekly Stat 15.xls]Not Read
Time'!$1:$65536,(sum(10:15)),FALSE))...... or something like that ..
basicly meaning i dont have to do a lookup for each column i need t
sum ...
 
A

Alan Beban

Clastir said:
. . . In some cases i require data to be summed in one row from
more than one colum ...like " =(VLOOKUP($A9,'[Weekly Stat 15.xls]Not
Ready Time'!$1:$65536,10,FALSE))+(VLOOKUP($A9,'[Weekly Stat 16.xls]Not
Ready Time'!$1:$65536,15,FALSE)) " and what i was woindering if i could
do is " =(VLOOKUP($A9,'[Weekly Stat 15.xls]Not Ready
Time'!$1:$65536,(sum(10:15)),FALSE))...... or something like that ...
basicly meaning i dont have to do a lookup for each column i need to
sum ....
Click to expand...

One way is array entering something like

=SUM(VLOOKUP($A9,'[Weekly Stat 15.xls]Not Ready
Time'!$1:$65536,{10,15},FALSE)) or

=SUM(VLOOKUP($A9,'[Weekly Stat 15.xls]Not Ready
Time'!$1:$65536,{10,11,12,13,14,15},FALSE))

Alan Beban
 
Top