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

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

I am using the following formulars:

My validation drop down list (D8) is linked to two date cells with these
formulars:
=IF(D8="","",VLOOKUP(D8,list!G:H,2,FALSE)) (cell D8)
=IF(F8="","",VLOOKUP(F8,list!H:I,2,FALSE)) (cellF8)

My total cell has the following formular:
=SUMPRODUCT(--(detail!$A$4:$A$4999=summary!F$8),--(detail!$A$4:$A$4999<=summary!G$8),--(detail!$B$4:$B$4999=summary!D10),detail!$D$4:$D$4 999)

The data sheet is called "detail"
My summary sheet is called "summary"
The sheet that link the month to the dates is called "list".

--
law


"Gary''s Student" wrote:

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