I have an Excel (2010) cell with this formula:
which works (the correct total is given). But when I enter another item to search for:
it does not work (total is zero). Does
AND not work in this case? Or have I made an error?
Explanation of code: I have two sheets, a Total sheet (where this code is placed) and a Tasks sheet. The Tasks sheet contains work priority (in H column), people (in I column) and estimated time (in F column). So I want to find out, per person and per tasks priority, how much work is estimated. The first line of code is just estimated time per person which, as I wrote, works fine. On the Total sheet, B4 contains the priority of the current item and C4 the name of the current person.