Specify date range

[Mary L.]

I have a column with the date field "11/10/03" format and another column of numbers. I want to sum the number column for those entries in November. Please help - thank you!!! I really appreciate it.

 

[Ron de Bruin]

Try this with the datse in B1:B10 it wil sum the cells in C

=SUMPRODUCT((MONTH(B1:B10)=11)*(C1:C10))

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)

I have a column with the date field "11/10/03" format and another column of numbers. I want to sum the number column for those

entries in November. Please help - thank you!!! I really appreciate it.

 

[Mary L.]

Hi - I keep getting a #VALUE! error because the number field is based on a VLOOKUP command and some fields in the number field and the date field are blank.

----- Ron de Bruin wrote: -----

Try this with the datse in B1:B10 it wil sum the cells in C

=SUMPRODUCT((MONTH(B1:B10)=11)*(C1:C10))

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)

I have a column with the date field "11/10/03" format and another column of numbers. I want to sum the number column for those

entries in November. Please help - thank you!!! I really appreciate it.

 

[Ron de Bruin]

No problem for me with a Vlookup function

You can send me your test workbook private if you want.
I try to find your problem