View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.newusers
Riccol Riccol is offline
external usenet poster
 
Posts: 21
Default 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?