I have a base of orders that have a customer_id a total cost and a paid column. I would like to know how I can do a formula that would find a customer_id and total all of their outstanding costs. So basically I need to sum total cost for a unique cus...

I would like to begin a search from a specific row however SEARCH("word to search for", columnname, 11) > 0 where 11 is the row position to start from. This, however, doesn’t seem to work. How can I get my search to not start from row 1

Is it possible to do a formula on a search wherein one statement search for 2 pieces of text in 2 columns? So I have one search SEARCH("Walker", PRODUCT) but I would like a search to also check SEARCH("scotch", TYPE) Is it possible to combine those 2...