Filling in Formulas

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
 
B

Bob Umlas

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top