| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
criteria applies to a range of dates.
A B C D
Employee: Mary Hire Date: 4/22/2006 Training Topic Hours Next Anniv. 4/16/08 Fish 7.5 4/22/2009 2/1/08 Birds 3 6/10/07 Cats 7.5 5/12/06 Dogs 3 ____ Total How can I SUM column C, only IF the dates in column A fall within a certain date range? The employee needs to complete 15 hours of ongoing training each year from anniversary to anniversary. (5/12/06 would not count for this years total because it started over on 4/22/07.) This person should have 18 hours of current training. I don't want to delete the previous trainings but I don't want them to show up in the current year total. I tried SUMIF but it keeps giving me 0. I want to sum the hours in column C if the training dates in column a fall within the calculated date range. (4/22/08 - 4/22/09) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with SUMIF using a range of dates as criteria | Excel Discussion (Misc queries) | |||
| Sum of data where a condition applies | Excel Discussion (Misc queries) | |||
| How to specify which cells/columns macro applies to? | Excel Worksheet Functions | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
| can I use a range of dates as a criteria when using sumif? | Excel Worksheet Functions | |||
Threaded Mode
