Totals don't add up

[dweir002]

Hello - I believe there is a way around this, but can't undersand (in my brain or in syntax) why below doesn't add up.  I tried a sumx but that didn't seem to work with functions.  Anyhelp is appreciated.  Thanks!