I've found a simple formula to sum the total number of unique values in a column of data (invoice numbers), but have run into a spot of bother when there are blank cells at ANY point in the column. If all cells in the referenced range contain a value, it works perfectly. Does anyone know how i can modify the formula to ignore all blank cells? I've tried it as an array formula, but still no luck. Any ideas?
=SUMPRODUCT(1/COUNTIF(CB1:CB50,CB1:CB50))
Cheers!
Bookmarks