| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum If range of dates date range, sum totals
I am trying to figure out how to sum a function if it apears between a set
given dates. my sheet looks something like this. YTD Bid Summary A B 1 10/12/08 25,000 2 10/28/08 75,000 3 11/25/08 50,000 4 Total 150,000 YTD Monthly Bid Summary A B 1 October Total of all October 2 November Total of all November 3 December Total of all December 4 Total I do not have my columns or rows named I tried using the following equation =SUMIF('YTD Bid Summary'!E6:E34,"=10/31/08",'YTD Bid Summary'!J6:L34)+SUMIF('YTD Bid Summary'!E,"10/01/08",'YTD Bid Summary'!J6:L38) It just says #NAME? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Breaking out Dates from a Date Range | Excel Discussion (Misc queries) | |||
| selecting the first date in a range of dates | Excel Worksheet Functions | |||
| return a date from range, date is between dates in two other cells | Excel Discussion (Misc queries) | |||
| How do I add totals from a range of dates depending on the month? | Excel Worksheet Functions | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Threaded Mode
