Using Date Range in Column "C" calculate values in "K"

[michae]

Hi Guys,

Struggling with this and wondered if you can help.

I have a spreadsheet which i have created listing invoices.
I would like to use a date range (All are in Column "C") and in date order.

Where a date is within that range i want the sum value counted at its value and added to an others that are found within the range.
Is it possible to do this.

Thanks in Advance for any assistance you can provide

Michael.mazak

 

[Joe4]

Is this what you are looking for?

Sum if date is between

To sum values between a given start and end date, you can use the SUMIFS function. In the example shown, the formula in cell G5 is: =SUMIFS(C5:C16,B5:B16,">="&E5,B5:B16,"

exceljet.net

 

[michae]

I think so Joe,

Want to do this

Col C2 01-01-19 Col K2 100
Col C7 05-01-19 Col K7 250
Col C9 25-01-19 Col K9 200
Col C10 31-01-19 Col K10 300

Answer should be 850 the SUM of all K's found that match column C criteria.

Regards

Michael.mazak

 

[Joe4]

OK, then try it and see how you do.
That link I provided walks you through an example of how to do that.
If you are having with a particular part, please post your formula attempt and describe the difficulty that is tripping you up.