Total cells of one column based on the values in another column?
I hadn't tried it because it didn't understand how the displayed values
could possibly be different than the actual values. But I tried it just
now, and you are correct, using "Formula IS" and your formula works
perfectly. I still don't understand it, but it IS working as it should
so I appreciate you "forcing" me to try it.
T. Valko wrote:
Yeah, but you're using a SUM formula so the values are *calculated*.
Did you try what I suggested?
|