How do I return a value....

[rbahbah]

...based on a date that falls between two given dates.

For example, I collected $100 on April 15 and another $200 on April 20. I need a formula that sums up all cash received in April between April 1 and April 30.

Thanks!

 

[AlanY]

try the sumifs() function

 

[Joe4]

Take a look at the SUMIFS function.
See here for an example on how to do that: https://exceljet.net/formula/sum-if-date-is-between