IF and SUM formula Problem

[sam.tidswell-norrish]

I have column C (1000 rows) with categories R1, R2 or R3.

I have column D (1000 rows) with amounts of money.

What formula do I use to calculate the sum of money for both R1, R2 and R3 individually?


Thanks!

 

[Michael M]

Hi Sam and welcome to the Board
Try

=SUMPRODUCT(--(C1:C1000="R1"),(D1:D1000))
OR
=SUMIF(C1:C1000,"R1",D1:D1000)

Change the text to suit

 

[sam.tidswell-norrish]

I'm afraid neither of these work...

 

[Michael M]

OK, then I think you may need to give us a little more info.
The formulae are fairly standard fare.

eg, are the categories exactly "R1", "R2", etc
have you ensured that the ranges in both column "C" and "D" are the same size in the formulae

 

[sam.tidswell-norrish]

I've worked it out. Thank you for your help nonetheless.

If you wanted to know, it was:

=SUMIF(sheet!$C$5:$C$1000,"R1",sheet!D$5:D$1000)

 

[Michael M]

Sam
Is the data on a different sheet ?
If not, the "sheet!" is redundant anyway, as are the "$" signs.

Regardless, glad you achieved the desired result !!

Cheers