CSE Array Not Calculating

[ssychr]

After updating the range in the formula below, I am no longer getting a calculation even after using Ctrl+Shift Enter.

Working: =SUMIF('ALL CODE DATA'!D$2:D$847,F2,'ALL CODE DATA'!P$2:P$847)/COUNTIFS('ALL CODE DATA'!D$2:D$847,F2,'ALL CODE DATA'!P$2:P$847,">0")

Not Working: =SUMIF('ALL CODE DATA'!D$2:D$1804,F2,'ALL CODE DATA'!P$2:P$1804)/COUNTIFS('ALL CODE DATA'!D$2:D$1804,F2,'ALL CODE DATA'!P$2:P$1804,">0")

Column D is text but has to be because of the formatting, however this doesn't seem to be the issue as the same data is used in the first formula.

Any tips on how to fix?

Thanks.

 

[JoeMo]

Doesn't look like CSE entry is needed. What does "not working" mean - returns an error? If yes, what error? Are there any cells with errors in them in the extended ranges?

 

[ssychr]

No error, but the formula is still view able in the cell as if it were entered as text. No errors in the ranges.

 

[JoeMo]

No error, but the formula is still view able in the cell as if it were entered as text. No errors in the ranges.

If you see the formula in the cell itself, that cell is formatted as text and the formula will not calculate. Click on the cell then Data>Text to Columns>Next and uncheck all the boxes and click the Finish button. That should make the formula active.

 

[ssychr]

Shucks, I had fixed this once before in the same cell and it defaulted back. That was the simple fix.

(And the CSE formula was the STDEV cell adjacent, not the SUMIF) Guess I haven't woke up yet today!

Thank you Joe!!

 

[JoeMo]

Shucks, I had fixed this once before in the same cell and it defaulted back. That was the simple fix.

(And the CSE formula was the STDEV cell adjacent, not the SUMIF) Guess I haven't woke up yet today!

Thank you Joe!!

You are welcome - thanks for the reply.