i am using this formula
=SUMPRODUCT('Monthly View'!D4:AA5000*MOD(COLUMN('Monthly View'!D4:AA4),2))
But it only does the even columns, it will not add up the odd columns as i just get all zeros in the Mod part of the formula or the even columns go to 1 not the odd columns
Any help would be appreciated
Bookmarks