Thread: A Query
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pankaj Trivedi Pankaj Trivedi is offline
external usenet poster
 
Posts: 3
Default A Query

On Nov 1, 4:53 pm, "Roger Govier" <rogerattechnology4NOSPAMu.co.uk
wrote:
Hi

One way
=SUMPRODUCT(--(TEXT($A$1:$A$100,"yymm")="0710"))

Or your could put the year and month in another cell, e.g. B1 and use
=SUMPRODUCT(--(TEXT($A$1:$A$100,"yymm")=$B$1))

--
Regards
Roger Govier

"Pankaj Trivedi" wrote in message

ups.com...

Hi,


I have been a user who have always done simple tasks like creating
table, formatting etc in Excel. But time requires that I need to get
used to using formula and other tools of excel therefore my query
might be so simple for the experienced users but I don't know how it
can be done. So excuse me for my ignorance:


I have a table that contains dates in one cell and time stamp in the
subequent cell and the same formate spanning over three months. I need
to exclude those cell having time stamp and count (month-wise) those
cells having date in them.


For example:


COLUMN A
31-Oct-07
10:49:27 PM
31-Oct-07
12:18:28 PM
30-Oct-07
12:32:27 PM


Can anyone help me?


Thanks,


Pankaj


Hi Roger,

Perhaps I am novice to understand the concept of array. I tried but
without success I am sure I must have created some sort of mess.

Anyways, I am thankful for your time and assistance.

Regards,

Pankaj