Adding up totals for the month

[shaftdx]

This is the spreadsheet I am working with, can someone please tell me how I can calculate the total price and gallons for the month automatically? is there a way to do it that it will read the dates in question and not the cells I specified? Like 9/1/20 - 9/30/20 = $$$$$ and no having me do the sum of cells c1:c10

 

[Joe4]

How about using the SUMIFS function to sum the values between two dates, like shown here: Excel formula: Sum if date is between | Exceljet

 

[shaftdx]

I think that will definitely work! Thank you!

 

[Joe4]

You are welcome!