I am trying to find a formula where is will count the unique values of the
text column if it meets the criteria of the date and number column. I
actually have a few different criterias, but thought this may be easier to
explain.

Date Number Text
200811 1 Cat
200901 2 Dog
200901 1 Mouse
200811 2 Frog
200811 1 Cat
200901 2 Bird

This is the formula I used, it worked when I only had two if conditions and
then I added a third and now it is giving me an #VALUE

=SUM(--(FREQUENCY(IF((AND($A$2:$A$50=E$1,$F$2:$F$50=$B41, $J$2:$J$50=$B$5)),MATCH($L$2:$L$50,$L$2:$L$50,0)), ROW(INDIRECT("1:"&ROWS($L$2:$L$50))))0))