LinkBack URL
About LinkBacks
Another option:
H3:
I3:
=SUMPRODUCT(1*(MONTH(Table1[Date])=Table2[[#This Row],[Month]]))
=SUMPRODUCT((MONTH(Table1[Date])=Table2[[#This Row],[Month]])*Table1[Price])
Another option:
H3:
I3:=SUMPRODUCT(1*(MONTH(Table1[Date])=Table2[[#This Row],[Month]]))
=SUMPRODUCT((MONTH(Table1[Date])=Table2[[#This Row],[Month]])*Table1[Price])
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks