I2=IFERROR(SUMPRODUCT(--(TEXT($B$2:$B$11,"mmyy")=TEXT(G2,"mmyy")),$D$2:$D$11)/H2,"")
and copy towards down
I2=IFERROR(SUMPRODUCT(--(TEXT($B$2:$B$11,"mmyy")=TEXT(G2,"mmyy")),$D$2:$D$11)/H2,"")
and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks