Sumif Multiple Columns

  • Thread starter Thread starter pzeitlin
  • Start date Start date
P

pzeitlin

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.
 
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.
Click to expand...

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