Thread
:
Help with SumIf
View Single Post
#
13
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Help with SumIf
Keep going lads, we've got him outnumbered. <g
--
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
with @tiscali.co.uk
"Pete_UK" wrote in message
ups.com...
Hi Roger, Sandy, Biff,
just to complete the range, with XL 2000 I also get 01/11/2006 when I
enter Nov-06. Must be something to do with Regional Settings.
Pete
Roger Govier wrote:
Sandy
XL2003
If I type Nov-06 into a standard cell or a cell preformatted as mmm-yy I
also see
01/11/2006
What a difference a stretch of water can make <vbg
--
Regards
Roger Govier
"Sandy Mann" wrote in message
...
"Biff" wrote in message
...
No typo.
mmmmmm......
It must just be me being the poor cousin again then <g
--
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
with @tiscali.co.uk
"Biff" wrote in message
...
No typo.
If I format a cell as mmm-yy and type in Nov-06 Excel (2002) shows it
in the formula bar as 11/6/2006.
If I don't preformat the cell and type in Nov-06 Excel automatically
converts it to 6-Nov and shows 11/6/2006 in the formula bar.
Biff
"Sandy Mann" wrote in message
...
If I type in Nov-06 Excel evaluates it as Nov 6 2006 not Nov 2006
I assume that it is a typo because my XL97 evaluates Nov-06 to
November 1 2006 not the 6th
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
with @tiscali.co.uk
"Biff" wrote in message
...
Hold on there a second.......
In column A I have the month and Year "Nov-06".
If you have dates like Nov-06 how do you know what day of the month
that is?
If I type in Nov-06 Excel evaluates it as Nov 6 2006 not Nov 2006
Seems to me that you should use the full date.
Biff
"Biff" wrote in message
...
Try this:
=SUMPRODUCT(--(ISNUMBER(A1:A10)),--(DAY(A1:A10)<12),C1:C10)
Biff
"Raj" wrote in message
...
I am new to using formulas in Excel and need some help with using
SumIf and a
date.
In column A I have the month and Year "Nov-06". I would like to
do is have
Column C Sum only if the current day is < 12 of the month.
Thanks
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann