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
|