So this formula is working, but i am trying to get the total sum on the last part of the formula in that range. Week1!N3:T100)
As you can see after H matches AH cells i need the total in that line range N to T. Any help thanks.
=SUMIF(Week1!H3:H300,GP!AH10,Week1!N3:T100)
As you can see after H matches AH cells i need the total in that line range N to T. Any help thanks.
=SUMIF(Week1!H3:H300,GP!AH10,Week1!N3:T100)