Sumif

[danielroberts560]

Hi

I am using a simple sumif formula that is picking up a cpmpletely different number!!!! For example, I am asking Excel to sum all those with an account number of A0012 and it is summing all those with an account number of W0015!! What am I doing wrong!! Im pretty sure the formula is correct - what else could it be?

 

[VoG]

What is your formula?

 

[T. Valko]

Hi

I am using a simple sumif formula that is picking up a cpmpletely different number!!!! For example, I am asking Excel to sum all those with an account number of A0012 and it is summing all those with an account number of W0015!! What am I doing wrong!! Im pretty sure the formula is correct - what else could it be?

Does your formula look something like this...

Book1
	A	B
2	A0012	99
3	A0012	86
4	W0012	28
5	DA0012	71
6	A0012	56
7	X0012	69
8	F0012	83
9	A0012	66
10	W0012	53
11
12	=SUMIF(A2:A10,"A0012",B2:B10)
Sheet3

 

[danielroberts560]

Yes but instead of having "a0012" it has a cell reference that has A0012 in it

 

[VoG]

Can you post the formula please.

 

[danielroberts560]

=sumif('worksheet2'!A:A,worksheet1!A2,'worksheet2'!E7:E127)

 

[Sandeep Warrier]

The unequal ranges might create a problem.

Have you tried

=sumif('worksheet2'!A7:A127,worksheet1!A2,'worksheet2'!E7:E127)

 

[T. Valko]

=sumif('worksheet2'!A:A,worksheet1!A2,'worksheet2'!E7:E127)

Your ranges need to match like this...

=SUMIF(worksheet2!A7:A127,worksheet1!A2,worksheet2!E7:E127)

The way it was working with your formula was:

A1...E7
A2...E8
A3...E9
A4...E10
A5...E11