| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sumif date is in certain month
I need to sum currency when the corresponding date is in a certain month. I
can not figure out the formula. For example: SUMIF(D2:D20,"5/31/05, <6/30/05",C2:C20) When the date in D is in the month of June, add the amount in C. I think the problem is in the calculation of the month. I have tried every thing I can think of, including using the (=MONTH). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy only the month from a date | Excel Worksheet Functions | |||
| Lookup the month in a date string 01/03/05 | Excel Worksheet Functions | |||
| Count the occurances of a month in a range of date fields | Excel Worksheet Functions | |||
| Month Year Date Format | Excel Worksheet Functions | |||
| Return the end of month date from a date | Excel Worksheet Functions | |||
Threaded Mode
