You are better off with sumproduct. Check out this site for further details...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Bookmark this site. It is a great reference...
--
HTH...

Jim Thomlinson


" wrote:

I have columns Person ("Adam", "Bob", "Charlie"), Day ("Monday",
"Tuesday", etc), Total. I'd like to SUMIF based on BOTH Person and Day
(e.g. sum for "Bob" and "Tuesday"). I'd rather not use PivotTables,
because (1) this is pretty simple and (2) people here are scared of
PivotTables. Can i use SUMIF based on 2 columns, either by
concatenating the text or with an array? Thanks.