how can i combine a sum function with if functions with many dates?
example:
=SUM(IF(MONTH(I30)=MONTH(N30),R40,0),IF(MONTH(I30)=MONTH(N31),R41,0))
month
Jan-09 (I30)
dates
1/3/09 (N30)
1/10/09 (N31)
values
5 (R40)
5 (R41)
if i have many months and many dates, can i change the function to =sum(if(month(I30)=month(N30:N31),R40:R41,0))
i think it could work in excel 2003 somehow but it can't work in excel 07, help anyone?
Bookmarks