I am having difficulty with a table in Excel 2007. For each line on the table I want a total of the number of times the letter c appears. However, I only want to check certain cells that are not adjacent to each other. So I can't put a range of cells in the formula to check. I can't use the regular Countif(s) syntax because it does not understand the seperation of the inputs by the commas. I have tried numerous different formulas with every symbol I can think of to no avail. So how do use this count formula when the cells you want the formula to look at are individual seperated cells and not ranges of cells?
Thanks!
Bookmarks