Jan 03 2023 11:59 PM
Need assistance to understand the formula to sum every Nth Column
The tutorials on internet does not seem to work
Thank you
Jan 04 2023 02:38 AM
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.