Adding only numbers in a column that contain certain text in another column
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!
Help Article Resources
Check out the Formula Handbook template!