Should I use if-then function?

  • Thread starter Thread starter Roz
  • Start date Start date
R

Roz

I have created a spreadsheet- we are selling seeds-
I have used the vlookup function so that if you type in
the word small it will populate the units and price per
one case of small seeds. example:

size - the variable- small, medium, large
units per case- =VLOOKUP(N3,sizes,2)
total # of units =N4*N2
Price/ unit =VLOOKUP(N3,Sheet2!$A$13:$B$21,2)
total price =N6*N5
(This is repeated for 200 customers)

This is working great, my question is- I need to generate
a report that will show me the total units bought of
small, medium, and large for all the customers on a new
spreadsheet. What functions would I use. THANK YOU FOR
YOUR HELP!!
 
Seems like you could use SUMIF, i.e. SUMIF(range containing text of size,
"small",range containing units)
 
Back
Top