Hello,
Anyone can help with the formula in cell D6, Sheet "Tot" in the excel attached.
Cannot make it works
Thanks a lot
CPS
Hello,
Anyone can help with the formula in cell D6, Sheet "Tot" in the excel attached.
Cannot make it works
Thanks a lot
CPS
D6=SUMPRODUCT((INDIRECT("'"&$B$6&"'!"&"C6:C8")=$C6)*(INDIRECT("'"&$B$6&"'!"&"D5:F5")=D$5)*(INDIRECT("'"&$B$6&"'!"&"D6:F8")))
Try this and copy across
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