ExcelNoob_111
New Member
Hello All,
I am attempting to write a formula using multiple criteria.
I would like to get a result that comes from the formula looking at 3 different columns of cells in a different tab.
Tab 1 ("Summary") has the summary table. In this table I would like to show a breakdown of a larger set of raw data in Tab 2 where the columns are located. The formula will go into each cell of the table in this tab.
Tab 2 (call it "Floor 1")
Look up column 1 (call it "Space) for the text status "Y"
Look up column 2 (call it "Room") for the text "A", "B", or "C"
Look up column 3 (call it "UIT") for the values that share the same row as column 1 and column 2 to get the result in Tab 1.
Example:
I want to see the total results of the specific UIT values from "Y" Space in "A" Room
So basically, I want to sort through columns 1 and 2, and show the TOTAL visible result based on the values in column 3.
I am currently using a SUMIF formula, but I have too many criteria, and have run into a wall as to which formula to use.
Please see attached for an example.
Any and all help will be greatly appreciated.
I am attempting to write a formula using multiple criteria.
I would like to get a result that comes from the formula looking at 3 different columns of cells in a different tab.
Tab 1 ("Summary") has the summary table. In this table I would like to show a breakdown of a larger set of raw data in Tab 2 where the columns are located. The formula will go into each cell of the table in this tab.
Tab 2 (call it "Floor 1")
Look up column 1 (call it "Space) for the text status "Y"
Look up column 2 (call it "Room") for the text "A", "B", or "C"
Look up column 3 (call it "UIT") for the values that share the same row as column 1 and column 2 to get the result in Tab 1.
Example:
I want to see the total results of the specific UIT values from "Y" Space in "A" Room
So basically, I want to sort through columns 1 and 2, and show the TOTAL visible result based on the values in column 3.
I am currently using a SUMIF formula, but I have too many criteria, and have run into a wall as to which formula to use.
Please see attached for an example.
Any and all help will be greatly appreciated.