SUMPRODUCT with skipping columns and column Breaks

Please provide a clickable link to the previous thread.

You are right - it's a new restriction. Here's the link for you: https://www.excelforum.com/excel-for...g-columns.html

Try this in C2, copied across and down:

=SUMPRODUCT((PLAN!$A$3:$A$7=REGISTER!$A2)*INDEX(PLAN!$C$3:$IM$7,,(1+4*(COLUMNS($A$1:A$1)-1))-3*INT((COLUMNS($A:A)-1)/13)):INDEX(PLAN!$C$3:$IM$7,,(4+4*(COLUMNS($A$1:A$1)-1))-3*INT((COLUMNS($A:A)-1)/13)))

Format shading & font colour black in year break columns.

Originally Posted by AliGW

You are right - it's a new restriction. Here's the link for you: https://www.excelforum.com/excel-for...g-columns.html

So.... we need to be much more lenient towards cross-posted threads!!!

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

Originally Posted by Glenn Kennedy

So.... we need to be much more lenient towards cross-posted threads!!!

FYI: the new restriction came into play only yesterday.

Originally Posted by AliGW

FYI: the new restriction came into play only yesterday.

Let's hope it reduces the number of spam ads for furniture, testosterone cream and whatever....

Off topic: @Ali: a lot of those threads included links in the thread title. Does it stop that too?