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
Rather than show us a formula that doesnt work, upload a sample workbook and show us what you expect - then we wont need to guess
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Perhaps
=SUMPRODUCT('Monthly View'!D4:AA5000*(MOD(COLUMN('Monthly View'!D4:AA4),2)=0))
Alternative to MOD(): ISODD or ISEVEN:
=SUMPRODUCT('Monthly View'!$D$4:$AA$5000*(ISODD(COLUMN('Monthly View'!$D$4:$AA$4))))
Ben Van Johnson
May be this
=SUMPRODUCT('Monthly View'!D4:AA5000*MOD('Monthly View'!D4:AA4,2))
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
@kvsrinivasamurthy:
Note: "SUMPRODUCT using MOD to sum odd columns"
Your formula calculates based on odd VALUES in row 4 cells vs. odd columns, i.e., E,G,...
Last edited by protonLeah; 05-26-2019 at 12:55 AM.
UltimateNeo says
But it only does the even columns, it will not add up the odd columns
@kvsrinivasamurthy
If all of the values in the cells are even then your suggestion will not add up any columns!
Note that the thread title and the question state odd columns, not odd values!
I tried the formula in a new file and it works =SUMPRODUCT('Monthly View'!D4:AA5000*(MOD(COLUMN('Monthly View'!D4:AA4),2)=0))
thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks