Forum Discussion
Excel 365 Sum of Nth Column
Need assistance to understand the formula to sum every Nth Column The tutorials on internet does not seem to work Thank you
Maybe this illustration will help you.
Example:
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:
=SUM(IF((RES(COLUMN(E25:BZ25),3)=2)*(ISNUMBER(E25:BZ25)),E25:BZ25))
Please finish with CTRL+SHIFT+ENTER.
without termination as an array formula:
=SUMPRODUCT((REST(COLUMN(E25:BZ25);3)=2)*1;E25:BZ25)
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.