Hello, I have formula of "=SUMPRODUCT(--(A682:AD682=A1:AD1))".
I want to drag down it to become "=SUMPRODUCT(--(A682:AD682=A2:AD2))".
But when I drag down it became "=SUMPRODUCT(--(A683:AD683=A2:AD2))".
How to change the drag down fill formula so it become like "=SUMPRODUCT(--(A682:AD682=A2:AD2)), =SUMPRODUCT(--(A682:AD682=A3:AD3))" and so on?
Thanks for the help.
Bookmarks