Need a formula to count data

I need some help. I am looking for a formula that will take data from one page and graph it on another page. The data I am trying to graph is arranged like so:

A B

1 q 2009.05.01
2 w 2009.05.02
3 w 2009.05.01
4 q 2009.05.01

I am looking for something that will look at column A and if the answer is "q" and then look at column B and if the answer is "2009.05.01" Excel will take that and count it in a specific cell on another page. In the case above, I want Excel to give me the answer of "2" in a designated cell.

Can someone please help me.

Thanks

Per forum rules do not post duplicate threads.

http://www.excelforum.com/excel-gene...f-formula.html

rbhedal

Please take a couple of minutes and read ALL theForum Rules

Duplicate threads are not allowed

thread closed