Specify date range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)




Mary L. said:
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
Click to expand...
entries in November. Please help - thank you!!! I really appreciate it.
 
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)




Mary L. said:
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
Click to expand...
entries in November. Please help - thank you!!! I really appreciate it.
 
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
 
Back
Top