Thread: sumif question

Hi, I am trying to use a sumif formula but can't get it to work.

I am using -

=sumif(E8:E45,"=A10",G8:G45)

Cell A10 is formatted as a number, as is column E. The value in Cell A10 is 5310 - if I change the formula to

=sumif(E8:E45,"=5310",G8:G45)

It works fine. But, referring the cell A10 in the sumif doesn't seem to work.

Can anyone tell me what I am doing wrong please?

Thanks,

Ben

marvellous, thank you

b