| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Added details only if it is within a certain month of the year
Hello, I am struggling with a formula that i wondered if anyone could asssit
me with? I am trying to get a calulation that only adds up all the figures in coloumn J (column only contains numbers) for the 10th month of 2009 (date is in column D). I have tried a few times but haven't had any joy. I would appreciate any assistance and guidance on this. What i have tried: =SUM(IF((--(TEXT('Air Imports'!D5:D10000,"mmyyyy")="102009")) =COUNTIF('Air Imports'!J5:J10000,IF('Air Imports'!D5:D10000,"mmyyyy")="102009") -- Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count month when date is in day/month/year format | Excel Worksheet Functions | |||
| Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| trying to get day/month/year froamt while user enters year only | New Users to Excel | |||
| details of month | Excel Worksheet Functions | |||
Threaded Mode
