Sumifs Formula Not Working While two criteria & between two dates

[avk]

In excel 2007, my sumifs formula not working with two criteria & between two dates.
I have attach sample file.

[AlKey]

Hi avk,

First, unmerge cells in col A and extend values in all rows, then use this formula.

Enter formula in C4 and copy across and down

=SUMPRODUCT((DATA!$A$2:$A$13=C$3)*(DATA!$B$2:$B$13=$A$2)*(DATA!$C$1:$LC$1>=$A4)*(DATA!$C$1:$LC$1<=$B4)*(DATA!$C$2:$LC$13))

[Khalidngo]

Hi avk,
You've probably missed this:

First, unmerge cells in col A and extend values in all rows, then use this formula.

One more thing, your drop down in calculation sheet having "Oil" with no trailing space.

Regards,

[azumi]

Hope this works

[avk]

Dear Alkey Sir, I use data validation & change segment from Spares to "Oil" or "Fil" or "V/B" then amount showing "Zero" I have attach sample file.

[avk]

Yes Khalidngo. Thanks