Hi
I have a SUMPRODUCT formula.
One of the columns is static (so each column needs to reference it for the formula ( A*B > A*C and so forth)
When I drag the formula it copies the first instance (which contains the static column, but the next one turns into a sequence and so forth.
Is there any operand to put in the formula so that if I drag it across many columns the reference column will stay in the equation but the next column will sequence?
Thanks
Bookmarks