Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with SUMPRODUCT
I'm trying to multiply and then sum the values in rows 2 and 7 starting with
column J. However, I only want to multiply and sum every other column. My formula is: =SUMPRODUCT(--(MOD(COLUMN($J$2:$BE$2),2)=0),--(MOD(COLUMN($J7:$BE7),2)=0)) I can't seem to get SUMPRODUCT to work on every other column (starting with column J). Any help would be greatly appreciated. Thanks, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
sumproduct | Excel Worksheet Functions | |||
Sumproduct...how to use *contain*? | Excel Worksheet Functions | |||
sumproduct | Excel Discussion (Misc queries) | |||
Sumproduct | Excel Worksheet Functions |