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

agwalsh
agwalsh used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Cost Accountant
Top Expert 2012
Commented:
Your dates in DW10 to FW10 are not dates. They are text:

put '=BR3' in DW10 and copy across and that will fix it.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial