| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum items occurring in a month and year
I've got the following formula to sum referrals received in a particular month.
Is it possible to make it specific to the year as well as the month? =SUM(IF(Referrals!$D$4:$D$10002='Referrals List'!$A5,IF(Referrals!$J$4:$J$10002=MONTH($B$2),1 ,0))) |
| 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) | |||
| Excel 2002 : How to sum up items by month, date and year ? | Excel Discussion (Misc queries) | |||
| trying to get day/month/year froamt while user enters year only | New Users to Excel | |||
| How do I add items within the last year | Excel Discussion (Misc queries) | |||
Threaded Mode
