Adding only numbers in a column that contain certain text in another column

Leslie Thomas

I need to add only the numbers in the SUBTOTAL VACANT USEABLE AREA column where the SUITE NAME column has the text "VACANT". Some of the suite names  have text in addition to "VACANT" . These numbers need to be included in the sum as well, but I've not been able to make this happen- the formula I'm using will only include the cells that only have "VACANT". I think the command "FIND" may be what I need, but I'm not familiar with how to use this command.  Whatever function I use, it will be repeated for multiple floors of a building. 

Thank you for your help! 

Leslie Thomas

Yes- It worked! Thank you so much!

L_123

=SUMIF([suite name]:[suite name], CONTAINS("Vacant", @cell), [subtotal vacant useable area]:[subtotal vacant useable area])

Leslie Thomas

Yes- It worked! Thank you so much!