one way:
=SUMPRODUCT(--(A1:A5=2000),--(A1:A5<3000),(C1:C5))
See
http://www.mcgimpsey.com/excel/doubleneg.html
for an explanation of how the -- works.
In article ,
Ivano wrote:
Hi,
I'm trying to add up the values in column C only if the the corresponding
values in Column A is Equal to and between 2000 and 3000, 3000 and 4000, 4000
and 5000.
A B C
1 2000 tom $10
2 2200 bob $20
3 4058 lue $50
4 3000 sue $6
5 4125 nik $8
This is what the answers should be:
2000 $30
3000 $6
4000 $58
This is what I have but I get 0 all the time. I can't figure out the
criteria part:
=SUMIF(A1:A5,A1:A5 AND(=2000,<3000),C1:C5)
Thanks
Ivano