This afternoon, I was working on my presentation style for my "Deal or No Deal: Furry Edition" panel at the upcoming #FurryFiesta2026 . Think of it as more of a rehearsal, so I can get used to tabbing between windows while still accessing the right information behind the scenes.
As I was testing it out with some dummy entries, I was caught off guard to see a "banker's offer" of zero when I wasn't expecting to. I looked closer at the formula, and determined that the zeroes I'd placed in some cells as dummy numbers, were being picked up by the formula as legitimate.
I spent a bit of time, determining how I could obtain the original desired result without having dummy zeroes affect the calculation. Then I remembered that similar intermediate calculations were also being run on a different sheet, where empty cells were skipped rather than being treated as having a zero value. I rewrote the "banker's offer" formula to reference these values instead, while also changing the COUNT function to a COUNTIF.


