N
NickVB
Hi
I have a formula that I am trying to have go all the way down the page
The formula is
=SUMPRODUCT((Clients!B1:Clients!B10654=C2)*(Clients!G1:Clients!G10654=B5))
However, when I try to fill in cells it changes all the values.
would like it to only change B1 to B2 etc. Any way I can do this?
Thank you
I have a formula that I am trying to have go all the way down the page
The formula is
=SUMPRODUCT((Clients!B1:Clients!B10654=C2)*(Clients!G1:Clients!G10654=B5))
However, when I try to fill in cells it changes all the values.
would like it to only change B1 to B2 etc. Any way I can do this?
Thank you