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
|