LinkBack URL
About LinkBacks
And a slightly more elegant solution:
=SUMPRODUCT(($E$5:$E$22-$C$5:$C$22>=30)*($B$5:$B$22=$H6)*($D$5:$D$22=I$4)*(($E$5:$E$22-$C$5:$C$22)))
Paste this formula into that table you provided
And a slightly more elegant solution:
=SUMPRODUCT(($E$5:$E$22-$C$5:$C$22>=30)*($B$5:$B$22=$H6)*($D$5:$D$22=I$4)*(($E$5:$E$22-$C$5:$C$22)))
Paste this formula into that table you provided
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks