=SUMPRODUCT(--(A1:A8="North"),--(B1:B8="High"))
Adjust ranges! You cannot use references to entire columns like A:A in
SUMPRODUCT.

Regards,
Stefi


€žRob E€� ezt Ã*rta:

Can anyone help please?

Column A contains instances of - North, South, East & West
Column B contains instances of - High or Low

Is there a way to count rows where co, A is North AND col B is High.

I have tried COUNTIF, IF, DCOUNTA, but I'm not sure of the right
function/combination.

Any help would be very much appreciated.

--
Thanks,
Rob E.