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