VLOOKUP
Hi Heather
what exactly do you want as output?
1 8 $25
then you would do following (assuming that you're first row is a
header)
=SUMIF(Sheet1!$A$2:$A$4,$A8,Sheet1!$B$2:$B$4)
which you can then drag to the right side, and then drag down.
hth
Carlo
On Jan 16, 1:47*pm, Learningfast
wrote:
Hi:
The dataset for the vllokup contains many rows with the same reference: *Ex
Coupon * # * * * * * * Transaction * * * * * * * * *Sales
1 * * * * * * * * * * * * *5 * * * * * * * * * * * * * * * *$ 10
2 * * * * * * * * * * * * *7 * * * * * * * * * * * * * * * * *$3
1 * * * * * * * * * * * * *3 * * * * * * * * * * * * * * * * * $15
When I write =vlookup(A3,"SheetName" $A;$E, 2,0) I only get one number for
each unique coupon # instead of a sum of all coupon numbers.
Can you help?
Thanks.
Heather
|