any formula other than this:andFormula:
=IF(B4<>"",B4*$B$2,IF(C4<>"",C4*$C$2,D4*$D$2))Formula:
=SUMPRODUCT((1*(B4:D4<>""))*($B$2:$D$2)*($B$4:$D$6))
any formula other than this:andFormula:
=IF(B4<>"",B4*$B$2,IF(C4<>"",C4*$C$2,D4*$D$2))Formula:
=SUMPRODUCT((1*(B4:D4<>""))*($B$2:$D$2)*($B$4:$D$6))
Last edited by reimar_rem; 01-31-2018 at 05:13 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks