View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
wx4usa wx4usa is offline
external usenet poster
 
Posts: 122
Default Sumproduct and Date format

On Dec 13, 8:35*am, Gary''s Student
wrote:
replace
(a2:a1000="december")
with:
(MONTH(A1:A1000)=12)
--
Gary''s Student - gsnu2007k

"wx4usa" wrote:
How do I use sumproduct to return December data from a database if the
range a1:a1000 is formatted mm/dd/yyyy? =sumproduct
((a2:a1000="december")*(b1:b1000))


Gary, Worked perfectly - Thank you.