SUMIF

[Angelo Battistoni]

I am trying to put this formula into a cell and it does not work.


=SUMIF(M:M,">800000 & <800999",O:O)

M O
1 800010 5.00
2 810000 6.00
3 800980 7.00

Thanks in advance!

 

[dvt]

I am trying to put this formula into a cell and it does not work.

=SUMIF(M:M,">800000 & <800999",O:O)

=SUMPRODUCT((M:M>80000)*(M:M<80099)*(O:O))

Dave
dvt at psu dot edu