I tried using the above answer for my prob but it didn't work. I need to find the total number of all the cells in a column with 'sold' in and all the cells in a different column with 'new' in. both of these must be true. I usually use the countif function but is doesn't seem to work when you...