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))}
If you are experiencing a similar issue, please ask a related question
Title | # Comments | Views | Activity |
---|---|---|---|
Help with Adding text from a form to a worksheet | 5 | 36 | |
Sum iF based on a null cell | 11 | 29 | |
In this macro, I would like to be prompted for a folder. | 7 | 18 | |
Error in formula not increasing value | 2 | 6 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!