Excel 365 Sum of Nth Column

Occasional Visitor

Need assistance to understand the formula to sum every Nth Column

The tutorials on internet does not seem to work

Thank you

1 Reply

@Leon_Naude 

Add nth column

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.

 

NikolinoDE

I know I don't know anything (Socrates)

Was the answer useful? Mark them as helpful!

This will help all forum participants.