Sumif Multiple Columns

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.
 
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.

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

Bernard Liengme

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top