Excel 365 Sum of Nth Column

Copper Contributor

Need assistance to understand the formula to sum every Nth Column

The tutorials on internet does not seem to work

Thank you

1 Reply


Add nth column

Maybe this illustration will help you.


E25: 30

F25: empty

G25: Instructor

H25: 20


Errors that can occur: If cell G25 is empty, the formula works, if G25 contains the text "Instructor", the formula returns the error #VALUE!


array formula:


Please finish with CTRL+SHIFT+ENTER.


without termination as an array formula:




Hope I was able to help you with this info.



I know I don't know anything (Socrates)

Was the answer useful? Mark them as helpful!

This will help all forum participants.