Getting any formula to stop at the next blank space

A

ajpowers

I frequently write VLOOKUP and SUMIF formulas for my spreadsheets an
have found myself typing the same thing over and over. How can I ad
in a command that makes each formula stop at the next blank. I als
have to make the formula references "absolutes". What I'm wanting t
do is copy and paste the same formula down without sacrifices th
absolute references
 
Top