extrapilating data

  • Thread starter Thread starter lbrunson
  • Start date Start date
L

lbrunson

I am downloading data from my Website from paypal. I would sell items b
1,5 pack, 10 pack ,25 pack, 50 pack and 100 pack. I have my column se
up so that I can sort the info by items id and then I can go in an
subtotal by count. Problem is that I would like for it to give me m
total individual count. I hope that I wrote this write so that you al
can interpet it .
Ex. 1 pack of 1 nut
1 pack of 5 nuts
1 pack of 10 nuts
1 pack of 100 nuts
total nuts sold was 116 nuts. simple example. Can anyone help
 
I hope I understood your problem correctly so here is a simple solutio
that I can offer:

Column A
(PackContents)
1
5
10
25
50
100

Column B
(No of packs sold)
1
1
1
0
0
1

Assuming that your data starts in row 2, your column C will look lik
this

Column C
(Nuts Sold)
=A2*B2
=A3*B3
=A4*B4
=A5*B5
=A6*B6
=A7*B7

And, if want an accum total of the nuts sold, you can put this i
Column D.

Column D
(Accum Total)
=sum($C$2:C2) copied down to D7

Hope this solution will help you.
 
Back
Top