Use Pivot table Option for this
On 12/3/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> I have to use Count function, and I have multiple criteria's for
> example I have to count the number of times a person's name is
> apperaring in a sheet and again count if he is active member or not
> f
Hi,
SumProduct is a better function to use in this case.
If your names are in A2:A100 and activity is in B2:B100, then:
=SUMPRODUCT(--(A2:A100="person's name")*(B2:B100="Active"))
You can replace "person's name" with an address (eg C1) and type the name you
want to search into that cell.
=SUMPROD
Hi,
Could u able to send any data and ur requirement?
Regards
Naveen Kumar M N
Transport Supervisor(HP)
91-08-99728 10886
Email :[EMAIL PROTECTED]
Best Wishes-Karunaada Kuvara
--- On Tue, 12/2/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
From: [EMAIL PROTECTED] <[EMAIL
Hi Frieds
I am receiving in store 10 types Raw Material on daily baises from
more than 30 suppliers. This data is arranged in one excel sheet by
truck wise.
I have to prepare the daily summary report Like in this order
First of all
Date
Material
But the problem will be that it will always convert to text. And date
functions will not work. The only way to work will be changing the format of
1000's of cells. You can select all cells in which data is there and in
which you want to put data together and just once you will need to change
the fo
Shannur ,
You may want to try the Dcount function in excel.
Rds ,
Vidya
On Wed, Dec 3, 2008 at 9:49 AM, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
>
> I have to use Count function, and I have multiple criteria's for
> example I have to count the number of times a person's name is
> apperaring
You can use a sumproduct function for this
Regards
Sathish Jalendran
-Original Message-
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of [EMAIL PROTECTED]
Sent: 03 December 2008 09:50 am
To: MS Excel & VBA Macros
Subject: $$Excel-Macros$$ Count function
I hav