=SUMPRODUCT(--(Year(C2:C100)=2006),--(A2:A100="RFP"))

"Tim Rowlan" wrote:

I have a spreadsheet with many many dates that I need to graph/chart. I want
to chart the number of RFPs I received in each year. How do I count on
column C which is a date column to see the number for any given year?
Thanks,
Tim