SUMIF

  • Thread starter Thread starter Angelo Battistoni
  • Start date Start date
A

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!
 
Angelo said:
I am trying to put this formula into a cell and it does not work.

=SUMIF(M:M,">800000 & <800999",O:O)
Click to expand...

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

Dave
dvt at psu dot edu
 
Back
Top