K so check out column B. When I add values to any of the empty cells the new values aren't included in the sum. Doesn't make sense. Changing the values of existing values doen't change the sum either.
Column D total: value doesn't change when any of the related cell values are changed.
Bookmarks