Link to home
Start Free TrialLog in
Avatar of agwalsh
agwalsh

asked on

sumproduct formula with truth table - not picking up what is true :-(

Thanks to all the lovely experts here I got a solution working. Alas, when I went to test it again today...seems to have stopped.  In cells M15 I have entered RES - the idea is that this will only be counted once as some can only resign ONCE. So based on that, I should have the number 1 in cell BS6 - which I created using the formulas and truth table (starting at DW10 - and that bit seems to be working - I have one true there). So what have I entered incorrectly? Thanks again.
EE_WTE_RES_calcs.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Steve
Steve
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial