i need to have a single formula that will count the number of times 4
different conditions are met. I 2 types of members, in 3 different markets.
i need to identify, the member type A, from market A, during January, that is
not duplicated.
i have the date converted to a text field in column B (labeled all january
dates as j110), market in column C, name in column E (last name space first
name) and member type in column H(indicated by an x in field if true). I am
using the following formula and it wont work. I could really use some help.
thanks.

=SUMPRODUCT(--('Total Class Attendance-Sign In'!C3:C20000="aus"),--('Total
Class Attendance-Sign In'!H3:H20000="x"),--('Total Class Attendance-Sign
In'!B3:B20000="j110"),--(('Total Class Attendance-Sign
In'!E3:E20000<"")/(CountIf('Total Class Attendance-Sign In'!E3:E20000,'Total
Class Attendance-Sign In'!E3:E20000&"")))