Are you using the SUBTOTAL() function rather than the SUM() function??
--
Gary''s Student - gsnu200759


"law" wrote:

This is driving me crazy.
I have a sheet with data. Column "A" is date, on my summary sheet I have a
validation drop down list with the names of the months. When I select
november on the drop down list it includes 1st December in the SUM.
Why is that happening???????????
--
law