How can I get excel to sum together data from a row from every 4th column automatically?
Example:
Sum D2+H2+L2+....
Please advice
How can I get excel to sum together data from a row from every 4th column automatically?
Example:
Sum D2+H2+L2+....
Please advice
TryFormula:Please Login or Register to view this content.
adapt range as needed
Another option
=SUM(FILTER(D2:T2,MOD(COLUMN(D2:T2),4)=0))
Thanks that worked!
Glad to help & thanks for the feedback.
Thanks for the rep
(Just to be sure, what solution actually worked? Both?)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks