December 11, 2020
July 16, 2010
Please use 'Show Values As' for these calculations. I would provide you with a sample file but my beta version of Excel is crashing when I try to use Show Values As. Yours should be fine though.