SUM TOTALS IF CATEGORY equals to defined values

**lemuel** · 04-23-2012, 05:58 PM

I'm not sure if the title is correct.

I'd like to sum up all total Orders, Sales of Category A,B,c ...etc from the tables of data on the other excel tab.

See attached sheet.

**Richard Buttrey** · 04-23-2012, 06:34 PM

B2:
=SUMIF(All!$A$2:$A$7,$A2,All!C$2:C$7)

copy to B2:C4

**lemuel** · 04-24-2012, 10:41 AM

Originally Posted by Richard Buttrey

B2:
=SUMIF(All!$A$2:$A$7,$A2,All!C$2:C$7)

copy to B2:C4

thanks for the solution but when copying the formula to the next row, A$2:A$7 becomes A$3:A$8 and so on... Is there any way to make it fixed or constant value? I have a lot of rows and columns on my actual sheet so editting the formula each cell in a tedious process.

**Cutter** · 04-24-2012, 10:44 AM

Copying (or dragging) A$2:A$7 down will not become A$3:A$8. It will remain as A$2:A$7. That's what the $ signs are for.
Copying A2:A7 down will become A3:A8.

**Richard Buttrey** · 04-24-2012, 11:21 AM

Hi,

I don't understand your comment.

Copying A$2:A$7 down can't possibly become A$3:A$8. The $ signs make the rows absolute - i.e. fixed.

If you've manually entered the formula I gave you and are getting the result you say then you have made a mistake in typing.

Regards

**lemuel** · 04-24-2012, 11:52 AM

Originally Posted by Richard Buttrey

Hi,

I don't understand your comment.

Copying A$2:A$7 down can't possibly become A$3:A$8. The $ signs make the rows absolute - i.e. fixed.

If you've manually entered the formula I gave you and are getting the result you say then you have made a mistake in typing.

Regards

Got it. I mistype the formula. Everything is ok now. Thanks everyone. This is SOLVED.