adjust so range doesn't include hidden items if hidden items are not supposed to be included in totals
additional adjust so range doesn't include hidden items if hidden items are not supposed to be included in totals