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