auto fill when using $ in formulas

Good evening kmbrenne
...and welcome to the forum!!

Originally Posted by kmbrenne

i feel like it has a simple answer

Not really, the formula is doing exactly what you ask of it by not incrementing the rows / columnsas you copy it down - that's exactly what the little dollar sign does (or making the formula absolute, to give it it's technical term, as opposed to ordinary relative formulae).

What you could do is download and install my add-in, via the link below, set the formulae up as normal relative ones, then highlight the range of formulae, go to Ultimate > Formulae > Relative / Absolute Formulae, and select Make Formulae Absolute from the drop down box.

That would achieve what you want to do, but it's not quite the simple answer you were after.

HTH

DominicB