Excel Sum Greater than but Less Than

Solved/Closed

Ian - Dec 14, 2009 at 08:04 AM
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?

Sum if greater than and less than cell value
Sum if greater than and less than - Best answers
Sum if less than or equal to - Best answers
If cell contains text then return value multiple conditions ✓ - Excel Forum
If cell contains date then return value ✓ - Office Software Forum
Count if cell contains number - Excel Forum
If cell contains specific text then return value in another cell ✓ - Excel Forum
Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum

2 responses

Answer 1 / 2

Darren
Jun 3, 2010 at 11:15 AM

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)

Similar discussions

Excel Macro to group by column & sum value

c++ program computing sum of squares of two

C program to print 1 11111 1111

if sum>= 60, color cells red

Sum values from one column if another column equals x

Similar discussions

Subscribe To Our Newsletter!