Filter with criteria!
 

Hello!

I have 2 woorksheet. One contains raw data one is a summary sheet.

In the raw data shhet, under the "catergory" column, I need to count and
filter out all the Apples" in this column. The challege is , the number of
apples counted should be from Jan, Feb and Mar respectively.

Results counted must be shown in the second worksheet in Column A, B and C
respectively, representing Jan Feb and Mar.

Can I have the formulae for this ?Thank you..
--
help me

Filter with criteria!
 

PivotTable
http://www.ozgrid.com/Excel/excel-pivot-tables.htm


--
Regards
Dave Hawley
www.ozgrid.com
"ernietan" wrote in message
...
Hello!

I have 2 woorksheet. One contains raw data one is a summary sheet.

In the raw data shhet, under the "catergory" column, I need to count and
filter out all the Apples" in this column. The challege is , the number of
apples counted should be from Jan, Feb and Mar respectively.

Results counted must be shown in the second worksheet in Column A, B and C
respectively, representing Jan Feb and Mar.

Can I have the formulae for this ?Thank you..
--
help me