This is a bit of an odd one, but, I need to count how many closing parentheses I've got in an excel column (and not just the number of fields in which it occurs, the total number, as there will be multiple occurrences per records).
Any excel gurus have some advice on what my formula should look like?
For the time being, I did a find/replace and replaced all ")" with ")q" as I didn't have any other q's on the page, but, using COUNTIF I only got the total number of records where the *Q* appeared (like 270), instead of the total number of Qs (which should be over 700).