Hello,
Im currently using SUMIF formula to get "Raw Information" from one sheet to the next. My question to you is, can SUMIF grab the text from a certain cell and then search another sheet for it?
That is the currently formula I'm using to get the information for "Unit 1" and the Qty of "Towel Bar" in that unit. I also have made the formula get the same info, but for Units 2 and 3. Is it possible to get SUMIF to grab the text from a certain cell that would be changing all the time?
If you take a look at the excel sheet I've linked, It shows that Towel Bar and Toilet Paper Holder are two different items, in two different cells. I'm wondering if I can have the formula look at the "Dynamic" cell (with the text inside) and then jump to the other sheet and grab the info needed.
Any help is appreciated! Thanks!
https://app.box.com/s/315fzzkhk3p74iojhd2i6si946itz0ac
Im currently using SUMIF formula to get "Raw Information" from one sheet to the next. My question to you is, can SUMIF grab the text from a certain cell and then search another sheet for it?
=SUMIFS('Raw Data'!C:C,'Raw Data'!A:A, "1",'Raw Data'!B:B, "Towel Bar")
That is the currently formula I'm using to get the information for "Unit 1" and the Qty of "Towel Bar" in that unit. I also have made the formula get the same info, but for Units 2 and 3. Is it possible to get SUMIF to grab the text from a certain cell that would be changing all the time?
If you take a look at the excel sheet I've linked, It shows that Towel Bar and Toilet Paper Holder are two different items, in two different cells. I'm wondering if I can have the formula look at the "Dynamic" cell (with the text inside) and then jump to the other sheet and grab the info needed.
Any help is appreciated! Thanks!
https://app.box.com/s/315fzzkhk3p74iojhd2i6si946itz0ac