I am looking to count the number of unique text cells in Col. A that meet
several criteria across Col. B-F.

And I'll want to do this calculation numerous times with changing criteria
(to fill out a large table).

Any ideas?