LinkBack URL
About LinkBacks
Vokey9 
I wasn't sure what you wanted... whether tou wanted a cumulative total. or what. So for EXPECTED (K21 drag down) I used:
=SUMPRODUCT(($F$20:$J$20>0)*$F$21:$J21)
for UNexpected, L21, drag down, I used:
=SUMPRODUCT(($F$20:$J$20=0)*$F$21:$J21)
I wasn't sure what you wanted... whether tou wanted a cumulative total. or what. So for EXPECTED (K21 drag down) I used:
=SUMPRODUCT(($F$20:$J$20>0)*$F$21:$J21)
for UNexpected, L21, drag down, I used:
=SUMPRODUCT(($F$20:$J$20=0)*$F$21:$J21)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hi Glenn,
Thanks very much for getting back to me so quick. I don't want a cumulative value I just want what you did but for the individual rows. How do I edit your formula to achieve this.
Kind regards.
Will
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks