Edit: Your formula is different than mine. Brackets are in a different place. I made the following example:
1 1 2 2 3 3 4 4 5 5 6 6 {=SUM(IF(MOD(COLUMN(A1:L1)
Which returns 21 as expected.
{=SUM(IF(MOD(COLUMN(K4:JS4),2)=1,K4:JS4),0)}
{=SUM(IF(ISNUMBER($J$3:$JR$3),J4:JR4),0)}
{=SUM(IF(ISNUMBER($K$3:$JS$3),0,K4:JS4))}
Title | # Comments | Views | Activity |
---|---|---|---|
Auto Operation of MS Excel 2013 | 2 | 29 | |
Query output to Excel producing error | 7 | 32 | |
VLOOKUP to a Closed Workbook | 22 | 62 | |
Gantt chart | 2 | 9 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
9 Experts available now in Live!