conditional Summing
 

I have sets of data similiar to this
Col. a col. b col. c
550 total 87.65
550 total 78.65
551 total 100.34
551 total 45.67
551 total 98.76
551 total 23.45
552 total 45.67
553 total 104.32

GRANDTOTALS
550 ???????
551 ???????
552 ???????
553 ???????

my desire is to add all values in col. a that are numbered 550 and add the
total of the TOTALS placing them on the bottom eg.
underneath the subheading GRANDTOTALS
553 ???????? would = 104.32
551 ???????? would = 227.22
etc....
is there a worksheet function that could do this?
in other words if col a matches the row under GRANDTOTALS then include that
number in the sum.

=SUMIF(Arange,550,Crange)

where you can use a reference to the cell housing 550 instead of 550 itself.

ben wrote:
I have sets of data similiar to this
Col. a col. b col. c
550 total 87.65
550 total 78.65
551 total 100.34
551 total 45.67
551 total 98.76
551 total 23.45
552 total 45.67
553 total 104.32

GRANDTOTALS
550 ???????
551 ???????
552 ???????
553 ???????

my desire is to add all values in col. a that are numbered 550 and add the
total of the TOTALS placing them on the bottom eg.
underneath the subheading GRANDTOTALS
553 ???????? would = 104.32
551 ???????? would = 227.22
etc....
is there a worksheet function that could do this?
in other words if col a matches the row under GRANDTOTALS then include that
number in the sum.

thank you,

That worked perfectly, i knew using the sumif formula was the answer just
could not come up with the proper form.


"Aladin Akyurek" wrote:

=SUMIF(Arange,550,Crange)

where you can use a reference to the cell housing 550 instead of 550 itself.

ben wrote:
I have sets of data similiar to this
Col. a col. b col. c
550 total 87.65
550 total 78.65
551 total 100.34
551 total 45.67
551 total 98.76
551 total 23.45
552 total 45.67
553 total 104.32

GRANDTOTALS
550 ???????
551 ???????
552 ???????
553 ???????

my desire is to add all values in col. a that are numbered 550 and add the
total of the TOTALS placing them on the bottom eg.
underneath the subheading GRANDTOTALS
553 ???????? would = 104.32
551 ???????? would = 227.22
etc....
is there a worksheet function that could do this?
in other words if col a matches the row under GRANDTOTALS then include that
number in the sum.