I have the following formula that is not working. Here is what I want the formula to do in cell B2 of the total worksheet: sum columns H-K from the sub worksheet where the sum of columns F and G <0 where the value in sub worksheet column A matches the value in column A in the total worksheet. The values in column A on both worksheets is an employee number and there are many instances of the same value
=SUMIFS(Sub!H$2:Sub!K$2,Sub!A$2:Sub!A$904,A2,Sub!F$2:Sub!G$2,"<0")
SUB WORKSHEET
TOTAL WORKSHEET
=SUMIFS(Sub!H$2:Sub!K$2,Sub!A$2:Sub!A$904,A2,Sub!F$2:Sub!G$2,"<0")
SUB WORKSHEET
TOTAL WORKSHEET
A | B |
321654 |