Sum every n cells in a row
This formula will sum every third row
{=SUM(cellrange * (MOD(ROW(cellrange), 3) = 0))}
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top
This formula will sum every third row
{=SUM(cellrange * (MOD(ROW(cellrange), 3) = 0))}