"speakers_86" wrote...
None of those formulas seem to work. I need a =countif that reffers to
a different sheet and looks at two ranges and two different criterias.

Ok...

Tell us EXACTLY which sheet and EXACTLY which two ranges and EXACTLY what
the two criteria are.

Biff