SumIf - when I fill down the Range, Criteria & sum range changes

M

markholt

I would like to fill down & keep the same range & sum range - but let the
criterial advance by 1 - field in the next file. Is this possible?

Also, will excel keep the info (function) straight as I sort the file?

Thanks much
 
S

Sheeloo

Add a $ to Col Letter and/or Row Number if you do NOT want it to change...
All other references (which are without a $ will change)
 

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