Countif in two columns ?

Here's what I'm trying to do. I have a document where in one column there's a list of dates and in another column a list of results. I am looking to have a countif that would include both columns, for example :
I want to know, (in 2005--first column), how many (g) there is in the other column. In the first column, it's not only 2005, there's a bunch of other years and there are a bunch of (g) in those other years. I'm trying to isolate the 2005 results and then, from those results, find how many (g) there are in the corresponding column. I do not want this as a filter, as I'm trying to do another sheet with statistics. That formula would be for the stats sheet, not just as a filter on the original sheet.

I can provide more information if needed, I don't know if I'm made myself clear. It's clear for me, but you don't have the document in front of you

Thanks for all your help !

Originally Posted by DonkeyOte

A sample file will help people provide more specific info but given use of XL2007 you might want to check out the COUNTIFS function in XL Help (a Pivot Table may also be viable).

Thanks, I checked out the help but couldn't figure out a way to do what I wanna do.
I'm attaching a very minimal sample of what I wanna do. You'll see the first sheet, then the stats sheet.

I have a yearly total and then from that total I want to isolate how many G's and how many P's I have. I want to use the dates in the last column of the first sheet

Originally Posted by DonkeyOte

Presumably you mean formulae for D2/D3 etc

D2: =IF(C2,COUNTIFS(Feuil1!$D$5:$D$24000,"G*",Feuil1!$H$5:$H$24000,"*"&C1),0)
Pending your locale config. you may need to change all commas to semi-colons in the above.

D3: =C2-D2

Formulae in D2:D3 can be copied and pasted into the other "blocks"

Thank you so much ! I'm always amazed at how quickly you guys come up with solutions haha
Thanks again