Hello, please help me:

I am attempting to count unique values across 3 columns, Title, Date, Time, in order to count how many distinct sessions have been offered. The title and time columns both have text values, and there are a few blank entries in the data.

I have tried a number of variations (SUM, SUMPRODUCT, COUNTIFS) but with no luck. When I enter the following formula, I get the wrong result:


Worse, when I try to troubleshoot by entering a very simple formula, that is =COUNTIF(A:A, A:A), the answer always comes up wrong (for some reason, it is only counting a small portion of the column. Any idea why?

I've tried to force the issue by reducing the number of rows and only entering =Countif(A2:A11, A2:A11), but the answer is still wrong. This occurs with both the title and time columns.


Would be very grateful for any advice. Thanks!