Array question re: Sum(If(ISNUMBER)....

[patriciaj]

Hi there,

I am at a loss to find the information I need to correctly proceed on a project I am working on.
I have created an array formula, which ignores #NA, to get a total for 4 columns... and this works fine.
BUT - when I copy/paste the formula to the other 1100 rows, it stays static, and thus does not change to reflect the (TRUE,FALSE,FALSE,TRUE) varied values, of the other rows.
How do I have the array formula become dynamic, because frankly I don't want to type in an individual formula for 1110+ rows, and I know there has to be a way to do this.
Any help or advice would be much appreciated.

(EXACT FORMULA is: =SUM(IF(ISNUMBER{TRUE,FALSE,TRUE,FALSE}, B6:B1208,0)) -- although technically the logical test part should (read=NEEDS TO) change, per each row.

Thanks,
P

 

[patriciaj]

Well, that worked! =SUMIF(B3:E3,"<1E100") PERFECTION! Apparently, I definitely overthought this.
AND I also caught my mistake, instead of CTRL+SHIFT+ENTER, I was using F9.... Which locked it in, and did not allow it to become dynamic.

Thanks all!

 

[T. Valko]

Well, that worked! =SUMIF(B3:E3,"<1E100") PERFECTION! Apparently, I definitely overthought this.
AND I also caught my mistake, instead of CTRL+SHIFT+ENTER, I was using F9.... Which locked it in, and did not allow it to become dynamic.

Thanks all!

You're welcome. Thanks for the feedback!