The sum range is proportional to the criteria range *even if you didn't
explicitly define it that way*.

Can't really tell what you're trying to do. Your sum range is within your
criteria range.


--
Biff
Microsoft Excel MVP


"evans.notch.cabin" wrote in
message ...
I am using SUMIF to sum monthly totals into a single worksheet, with values
coming from individual weekly worksheets (these are in the same workbook).
The result is including values that are not in the specified sum_range -
specifically from column D. It is only including the value from column D
once (vs. 5 times, once for each weekly worksheet).

Complete formula is below, where
'Monthly Totals'!$B10 is criteria
B:O is range in each Weekly worksheet (ie, 'Week 1 STAFF'!$B:$O)
sum_range is K:K in each weekly worksheet
Criteria appears in column B in each Weekly worksheet
Erroneous value appears in column D in each Weekly worksheet

=SUMIF('Week 1 STAFF'!$B:$O,'Monthly Totals'!$B10,'Week 1
STAFF'!K:K)+SUMIF('Week 2 STAFF'!$B:$O,'Monthly Totals'!$B10,'Week 2
STAFF'!K:K)+SUMIF('Week 3 STAFF'!$B:$O,'Monthly Totals'!$B10,'Week 3
STAFF'!K:K)+SUMIF('Week 4 STAFF'!$B:$O,'Monthly Totals'!$B10,'Week 4
STAFF'!K:K)+SUMIF('Week 5 STAFF'!$B:$O,'Monthly Totals'!$B10,'Week 5
STAFF'!K:K)

Any thoughts?