Filter problem

  • Thread starter Thread starter law
  • Start date Start date
L

law

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???????????
 
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$4999)

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