software

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(gt;=2000,lt;3000),C1:C5)

Thanks
Ivanoone way:

=SUMPRODUCT(--(A1:A5gt;=2000),--(A1:A5lt;3000),(C1:C5))

See

www.mcgimpsey.com/excel/doubleneg.html

for an explanation of how the -- works.

In article gt;,
Ivano gt; wrote:

gt; Hi,
gt; I'm trying to add up the values in column C only if the the corresponding
gt; values in Column A is Equal to and between 2000 and 3000, 3000 and 4000, 4000
gt; and 5000.
gt;
gt; A B C
gt; 1 2000 tom $10
gt; 2 2200 bob $20
gt; 3 4058 lue $50
gt; 4 3000 sue $6
gt; 5 4125 nik $8
gt; This is what the answers should be:
gt;
gt; 2000 $30
gt; 3000 $6
gt; 4000 $58
gt;
gt; This is what I have but I get 0 all the time. I can't figure out the
gt; criteria part:
gt; =SUMIF(A1:A5,A1:A5 AND(gt;=2000,lt;3000),C1:C5)
gt;
gt; Thanks
gt; Ivano