I am trying to create a sheet that refrences a table of tiles we are installing. I want it to parse if the tile is large or small, and then if it is on a slab or crawl space(first or second floor)

I am using this formula to determine if what floor it is.

=IF(B6="crawl",(SUMIF(Sheet1!I12:I19,"0",Sheet1!K12:K19) SUMIF(Sheet1!I12:I19,"-1",Sheet1!K12:K19) SUMIF(Sheet1!I12:I19,"basement",Sheet1!K12:K19)),(SUMIF(Sheet1!I12:I19,"1",Sheet1!K12:K19))) -1,1,basement are all "slab" spaces. I want to incorporate your equation so that it checks if it is large, and if it is, to do my equation. But if its not large, to output 0.

To determine if the tile is large or small I'm using

=IF(IF(VALUE(LEFT(A2;FIND("x";A2)-1))>13;1;IF(VALUE(RIGHT(A2;LEN(A2)-FIND("x";A2)))>13;1;0))=1;"Large Tile";"Small Tile")