sumif values are same

  • Thread starter Thread starter crapit
  • Start date Start date
C

crapit

How do I sum column A if the value C is common?

A B C
15.2 2 aa1
23.0 1.5 aa1
12.3 1.5 aa1
0.7 1.5 aa1

15.2 2 bb1

15.2 2 cc1
23.0 1.5 cc1
12.3 1.5 cc1
0.7 1.5 cc1
 
Try this:

=SUMIF(C:C,"aa1",A:A)

will add all the values in column A which have a value of aa1 in the
corresponding cell of column C.

Hope this helps.

Pete
 
Can you please explain a little clearer perhaps with an example of the
summation result from the dataset posted
 
Almost there, but the value is not always aa1, bb1, cc1. I try subsitute "aa1" with the cell e.g C2, C3, C4 and so forth at column 'D', but I dont want to see repeating total sum at 'D' column as highlight in BOLD. Note at D1 and D10, both must be shown as their C column are different
A B C D
Click to expand...
1 15.2 2 aa1 51.2
2 23.0 1.5 aa1 51.2
3 12.3 1.5 aa1 51.2
4 0.7 1.5 aa1 51.25 15.2 2 bb1 15.26 15.2 2 cc1 57.2
7 18.0 1.5 cc1 57.2
8 12.3 1.5 cc1 57.2
9 11.7 1.5 cc1 57.2

10 15.2 2 dd1 51.2
11 23.0 1.5 dd1 51.2
12 12.3 1.5 dd1 51.2
13 0.7 1.5 dd1 51.2

Try this:

=SUMIF(C:C,"aa1",A:A)

will add all the values in column A which have a value of aa1 in the
corresponding cell of column C.

Hope this helps.

Pete
 
Put this formula in D1:

=SUMIF(C:C,C1,A:A)

and this one in D2:

=IF(C2=C1,"",SUMIF(C:C,C2,A:A))

Then copy the second formula down as required.

Hope this helps.

Pete
 
U R marvellous. Thanks for the great help
Put this formula in D1:

=SUMIF(C:C,C1,A:A)

and this one in D2:

=IF(C2=C1,"",SUMIF(C:C,C2,A:A))

Then copy the second formula down as required.

Hope this helps.

Pete
 
Back
Top