Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif Multiple Columns
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif Multiple Columns
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif Multiple Columns
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"),D6:D57) 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 -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF, One criteria multiple columns | Excel Discussion (Misc queries) | |||
SUMIF - multiple criteria in different columns | Excel Worksheet Functions | |||
SUMIF and multiple columns | Excel Discussion (Misc queries) | |||
SUMIF over multiple columns | Excel Worksheet Functions | |||
Sumif over multiple columns | Excel Worksheet Functions |