Excel Sum Greater than but Less Than
Solved/Closed
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?
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?
Related:
- Sumif greater than 0
- Sum if less than excel - Best answers
- Sum if greater than and less than - Best answers
- Excel mod apk for pc - Download - Spreadsheets
- Dash becomes date on excel ✓ - Office Software Forum
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Number to words in excel - Guide
