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

This is the formula I have but I am getting 0 as a result.
Thanks

"Raj" wrote:

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

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

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

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

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

"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

=SUMIF(A1:A15,"<11/7/2006",C1:C15)

"Raj" wrote:

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