View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob E Rob E is offline
external usenet poster
 
Posts: 9
Default Countif Using Multiple Columns

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.