On Dec 17, 3:24 pm, wrote:
Thanks for the help on the first part of the question. Now, I have a
named range to represent a section of data that represents a date
(colums) and people (rows).

I want to create a sumif for multiple columns. Basically, sumif three
columns (B,C,D) based on column A criteria being true: my formula is
currently sumif(c8:c57,"criteria",d8:i57). Does this need ot be some
type of array formula?

As always, thanks.

nevermind..figured it out..sumproduct works fine. Thanks all.