View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tamara Tamara is offline
external usenet poster
 
Posts: 7
Default Countif for 2003

I have a spreadsheet that lists individual and renewal month:

A 1/1
A 2/1
A 1/1
B 1/1
B 2/1
B 1/1

I'm trying to count the total number of January renwals for "A" and January
renewals for "B" on a separate "Totals" page. The person I'm creating this
for has 2003 while I have 2007. I tried the "COUNTIFS" last time and it
doesn't produce a result for them. I'm banging my head against the wall.
Any help is appreciated.