| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Year as well as month in formula
How can I include the year in this formula?
SUM(IF([Referrals10.xls]Referrals!$D$4:$D$250='[Referrals10.xls]Referral Source'!$A5,IF([Referrals10.xls]Referrals!$J$4:$J$250=MONTH(B$2),1,0))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
| Date formula where month and day remain the same, but year will va | Excel Worksheet Functions | |||
| To detect month or days or year in if formula | Excel Discussion (Misc queries) | |||
| convert number to month and year in formula | Excel Worksheet Functions | |||
| trying to get day/month/year froamt while user enters year only | New Users to Excel | |||
Threaded Mode
