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.
Use the "$" symbol to create absolute references on what you want to lock. Your formula would then become:
=SUMPRODUCT(--(A$682:AD$682=A1:AD1))
Try
=SUMPRODUCT(--(A$682:AD$682=A1:AD1))
it worked, thank you so much everyone. ^^
Make the range to absolute reference, it freezes the range.
By using the below formula, you can drag it to up, down, left and right.
SUMPRODUCT(--($A$682:$AD$682=A1:AD1))
By using the below formula, your value will change if you drag it left or right.
=SUMPRODUCT(--(A$682:AD$682=A1:AD1))
Now, choice is your's
You're welcome. Glad we could help.Originally Posted by nova312
If this solved your question, please mark this thread as SOLVED.
Hi
Make the A682:AD682 absulute. i.e.
Formula:
Please Login or Register to view this content.
However it looks an odd sort of use of a SUMPRODUCT. What is it you're doing with the formula?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Edit: Removed duplicate post.
Just to calculate multiple choice test score, thanks again everyoneHi
Make the A682:AD682 absulute. i.e.
Formula:Please Login or Register to view this content.
However it looks an odd sort of use of a SUMPRODUCT. What is it you're doing with the formula?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks