SUM IF


J

Joseph

I am trying to add all of the values below that fall between 2 and less than
3. Any ideas?

1 10
1.1 10
1.2 10
1.3 10
1.4 10
1.5 10
1.6 10
1.7 10
1.8 10
1.9 10
2 5
2.1 10
2.2 10
2.3 10
2.4 10
2.5 10
2.6 10
2.7 10
2.8 10
2.9 10
3 10
3.1 10
3.2 10
3.3 10
3.4 10
3.5 10
3.6 10


Thanks for any assitance.

Joe
 
Ad

Advertisements

P

Peo Sjoblom

=SUMIF(Range1,">=2",Range2)-SUMIF(Range1,">=3",Range2)

or

=SUMPRODUCT(--(Range1>=2),--(Range1<3),Range2)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top