spread sheet formula

  • Thread starter Thread starter Rick R
  • Start date Start date
R

Rick R

I have a spread sheet with colum "A" contaning 145 rows of
data. In this range there are 12 different products in
order of when they were purchased.
In column "B" the rows contain the amount of items
purchased, based on a certain criteria.
In Column "C" the rows contain the amount of items
purchased , based on a different criteria.
I need to sum up the # on units for each of the 12
products in column B and again for column C. Is this sort
of thing possible.
 
Rick,

This is possible using the SUMIF function.

Basically, SumIf will total based on a specific criteria
that you nominate.

Given the following info in the range a1:c5
a 2 4
a 3 5
b 1 2
c 3 3
a 1 6

in cell b6 enter the formula
=SUMIF(a1:a5,"a",b1:b5), the result "6" will be displayed
likewise in cell c6 enter
=SUMIF(a1:a5,"a", c1:c5), the result 15 can be displayed.

This can get complex if you have multiple criteria and
multiple results to report on.

Have you had a look at the DATA/SUBTOTAL options? when
doing this sort of work, that's generally what I use.

Steve
 
Rick,

You can use the SUMIF function, wich has the following
syntax:

=SUMIF(Reference_range,Criteria,Sum_range)

In your example you could write the product names in cells
D1:D12 and use the formulas:
=SUMIF($A$1:$A$145,D1,$B$1:$B$145)
and
=SUMIF($A$1:$A$145,D1,$C$1:$C$145)

Copy these formulas for all products, and that's it.

Regards,
Felipe
 
Back
Top