Thanks for the feedback and to Dave for the really detailed explanation!
Stefi


€žRob E€� ezt Ã*rta:

That works perfectly. Thank you very much.

Is there an easy explanation as to why the 2 hyphens (--) are necessary
please?

Sorry to bother you again.
--
Thanks,
Rob E.


"Stefi" wrote:

=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.