Prev: how to change the pivot chart automaticaly as values in the worksheet change
Next: countif/sumproduct + month
From: MM on 3 May 2010 15:41
Afternoon all,
You've helped out before and I come to you again. Here's the question...

5 worksheets in my workbook, each representing a different office.
Column A for each worksheet is the date in the following format: 03-May-10.
Let's say the first sheet is named Montreal Office, the search range is
A3:A5000, what formula am I supposed to use? I think from past posts, I'm
supposed to use =sumproduct but I don't know how to incorporate my specific
sheet.

Thanks so much,
MM
From: David Heaton on 3 May 2010 20:46
On May 4, 5:41 am, MM <M...(a)discussions.microsoft.com> wrote:
> Afternoon all,
> You've helped out before and I come to you again.  Here's the question....
>
> 5 worksheets in my workbook, each representing a different office.
> Column A for each worksheet is the date in the following format: 03-May-10.
> Let's say the first sheet is named Montreal Office, the search range is
> A3:A5000, what formula am I supposed to use?  I think from past posts, I'm
> supposed to use =sumproduct but I don't know how to incorporate my specific
> sheet.
>
> Thanks so much,
> MM

I dont understand what the question is.

Please explain it a little better.

David
From: bala_vb on 4 May 2010 01:54

'David Heaton[_2_ Wrote:
> ;950871']On May 4, 5:41*am, MM <M...(a)discussions.microsoft.com> wrote:-
> > Afternoon all,
> > You've helped out before and I come to you again. *Here's the
> question....
> >
> > 5 worksheets in my workbook, each representing a different office.
> > Column A for each worksheet is the date in the following format:
> 03-May-10.-

Hi,

one alternative approach. using wild characters with countif function

If you want to count the occurence of MAY in sheet2,

=COUNTIF(Sheet2!A1:AZ60000,"*May*")

similarly you can use, "??May*" etc.

Thanks
Bala




--
bala_vb
From: Bernd P on 4 May 2010 05:50
Hello,

If you do not mind a macro:
http://sulprobil.com/html/sfreq.html

If you do:
http://sulprobil.com/html/countif.html

Regards,
Bernd
From: MM on 4 May 2010 11:27
Thanks David. I was having errors trying to post my question yesterday. Lo
and behold, it posted 4 times and I did get replies to my question.
Thanks again.
MM

"David Heaton" wrote:

> On May 4, 5:41 am, MM <M...(a)discussions.microsoft.com> wrote:
> > Afternoon all,
> > You've helped out before and I come to you again. Here's the question....
> >
> > 5 worksheets in my workbook, each representing a different office.
> > Column A for each worksheet is the date in the following format: 03-May-10.
> > Let's say the first sheet is named Montreal Office, the search range is
> > A3:A5000, what formula am I supposed to use? I think from past posts, I'm
> > supposed to use =sumproduct but I don't know how to incorporate my specific
> > sheet.
> >
> > Thanks so much,
> > MM
>
> I dont understand what the question is.
>
> Please explain it a little better.
>
> David
> .
>
 | 
Pages: 1
Prev: how to change the pivot chart automaticaly as values in the worksheet change
Next: countif/sumproduct + month