Filling in Formulas

  • Thread starter Thread starter NickVB
  • Start date Start date
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
 
=SUMPRODUCT((Clients!B1:Clients!B$10654=C2)*(Clients!G1:Clients!G$10654=B5))
if that's not right, you should place a "$" before any row or column you
don't want to change when filling.

Bob Umlas
Excel MVP
 
Back
Top