Help With Excel

Closed
Soup - 9 Sep 2009 à 15:57
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 - 12 Sep 2009 à 00:56
Hello,

I'm not sure quite how to get my spreadsheet to do what I need it to do. I have two tabs set up in the workbook; the first tab has a list of dates in column A, and a list of values in column B. In the second tab I need to set it up so that if I enter a range of dates from column A it will display the sum of the values in column B within that same range. So for example, if I want to know the total distance covered between September 9 and September 18, I can input 9/9/2009 in one cell, input 9/18/2009 in another cell, and then a third cell will tell me the distance covered between those days.

I don't know very much about the formulas in Excel, or using macros, so I really need some help...

Thanks
Related:

1 response

Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 307
12 Sep 2009 à 00:56
Try the formula
=SUM((A1:A19<=$D$5)*(A1:A19>=$D$4)*(B1:B19)) Press CTRL + SHIFT + ENTER To enter the formula
where A1:A19- dates
D5 - end date
D4 start date
B1:B19 - Your values