Re: Sum Multiple columns within Vlookup
From: Alan Beban (unavailable_at_no.com)
Date: 05/06/04
- Next message: LLP: "wrong number appears"
- Previous message: Cody: "Re: Web Link"
- In reply to: Clastir: "Re: Sum Multiple columns within Vlookup"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 06 May 2004 11:03:09 -0700
Clastir < wrote:
> . . . 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 ....
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
- Next message: LLP: "wrong number appears"
- Previous message: Cody: "Re: Web Link"
- In reply to: Clastir: "Re: Sum Multiple columns within Vlookup"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
