Hi Jonmo1,

Its the only way I could count individual occurances using the filter. It seems the formulas which have been suggested may have been double counting. Example: if A25 = 630, B25 = CA-blablah, C25 = blank, then total count equals 2 where as i'm looking to have it count once.

I'm sure its me, everyone. Sorry for any confusion.