Formula not calculating correct figures from SumProduct table.
Thanks to all the brilliant 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
Microsoft OfficeMicrosoft ExcelMicrosoft Applications