Excel Sum Greater than but Less Than [Solved/Closed]

Ian - Dec 14, 2009 at 08:04 AM - Latest reply:  Alli
- Nov 29, 2010 at 02:18 PM
Hello,

I am trying to get a cell to show the answer if -
The date in B5 minus the date in B10 is less than 60 but more than 30 then F10 should show the value in C10, the answer in all other cases should be zero.

So far I have managed to get the sum to show this if the value is less than 30. -
=IF($B$5-$B$10<=30, C10, 0)

Anyone able to help?
See more 

4 replies

Best answer
10
Thank you
Mabey you have an answer already but for others this will help with other things. Use an AND statement

=IF((AND($B$5-$B$10<60,$B$5-$B$10>30)),C10,0)

Thank you, Darren 10

Something to say? Add comment

CCM has helped 1891 users this month

3
Thank you
Hi Ian,

Try this formula in F10:
=IF(B5-B10<60,IF(B5-B10>30,C10,0),0)

Best regards,
Trowa
Thanks Trowa,

I actually got it to work in the end (3hours of head scratching) using -

=IF($B$5-$B10>=29, $C10, 0)-IF($B$5-$B10>=60, $C10, 0)

I like your version better though so I'll be changing it.

Thanks again.
Very helpful for a problem I was also having - thanks very much