View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaffnr Gaffnr is offline
external usenet poster
 
Posts: 65
Default COUNTIF - across 2 columns

Hi Rebekah,
Im sure there is a better way to do this but the below will work.
In column c do: =and(A1=10,B1=2008).
this will produce a true/False result.
Then simply do a countif of on true in column C
--
Rob Gaffney


"Rebekah" wrote:

I'm hoping somebody can help me, as I feel this formula should be simple, but
I can't get it to work!

I have 2 columns
A B
10 2008
11 2008
10 2009

I need to count how many time column A records the occurance of "10" when
column B records the occurance of "2008".

Please help!

Beks