Sumif Multiple Columns

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

 

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

 

[Bernard Liengme]

I did not see your first message so am unsure what is needed but it looks
like something for SUMPRODUCT.
To sum the D range subject to three criteria relevant to other ranges:
=SUMPRODUCT(--(A8:A157="Bert"),--(B8:B57="apples"),
--(C1:C57="Monday"),D657)
will sum D column for all the apples Bert purchased on a Monday
For more details on SUMPRODUCT
Bob Phillips
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
J.E McGimpsey
http://mcgimpsey.com/excel/formulae/doubleneg.html
best wishes