Sumifs totals - how to carry formula to other columns

alwayslearning

I am using a sumifs formula with the same criteria to total 15 columns on my sheet. How do I carry this formula to other columns to maintain the criteria and sum up the total of the column it was carried to? I saw posts from 2018 saying this wasn't possible. Is there newer information on this? I appreciate any help you can provide. I would rather not have to rewrite the formula for each column. Thanks in advance!

Darren Mullen

@alwayslearning I don't know what your formula looks like, but it sounds like all you'd have to do is change the reference to the new column you want to sum and leave the rest the same.

alwayslearning

@Darren Mullen I was hoping I could write the formula in the first column and then "drag" the formula to the other columns. I thought it would automatically update to reference each new column. But that doesn't work. I copied the formula to every cell of the three rows and 15 columns and then changed each reference. It was time-consuming. Happy New Year!