Help with search terms, need VLOOKUP equivalent for multiple rows w/ same identifier

  • Thread starter Thread starter a029223
  • Start date Start date
A

a029223

Hey there, Duane, thanks for the reply. The second sheet is set up wit
the store numbers all down column A -- there are headers, and the
entries for each store that I have sorted by sales, descending. Lik
this:

Store Customer Assets Sales
101 Smith $356.4 $200,300
101 Jones $10.5 $196,543
101 Wallensky $245.3 $157,400
...
102 Mbutu $600.0 $190,200
102 Grace $1,234.1 $189,440
102 Freeman $30.5 $107,989
...
and so on, down to the last store.

Each store might have between 30 and 100 customers, it depends.

Any hints you might have would be great! Thanks -- Emil
 
if the first line of data is in row 2, and the store #'s are in colum
a

this allows up to 999 rows of data (rows 2:1000)

this will add up the first 20 entries in column c for the store
specified in cell a1001

=SUM(OFFSET(C$1,MATCH($A1001,$A$2:$A$1000,0),0,1,1):OFFSET(C$1,MATCH($A1001,$A$2:$A$1000,0)+19,0,1,1))

there has to be at least 20 rows for each store or you will get ba
result - I think this could be fixed though

is the sum what you wanted to "bring in"
 
Back
Top