autosum function

Copper Contributor

i am trying to use autosum to add the values in every 8th cell of a column.  the formula i tried was =sum(f11:f419*(mod(row(f11:f419),8)=0)). this is an excel formula i found online, but it is not working as it should. i am a new excel user

1 Reply


You have to enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.

sum every 8th row.png

The screenshot is from Excel 2013 and it works as intended after the formula is confirmed as an arrayformula with ctrl+shift+enter.