Prev: Macros to Button
Next: Change Default Auto-Fill-In month
From: ernietan on 15 Apr 2010 03:41
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

From: ozgrid.com on 15 Apr 2010 04:40
PivotTable
http://www.ozgrid.com/Excel/excel-pivot-tables.htm


--
Regards
Dave Hawley
www.ozgrid.com
"ernietan" <ernietan(a)discussions.microsoft.com> wrote in message
news:0A3D3E1C-FF8D-4FC1-872C-FCD61B93E824(a)microsoft.com...
> 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
>

 | 
Pages: 1
Prev: Macros to Button
Next: Change Default Auto-Fill-In month