Sumifs Formula Not Working While two criteria & between two dates

**avk** · 03-29-2016, 10:01 AM

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

**AlKey** · 03-29-2016, 10:25 AM

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

Formula:

Please Login or Register  to view this content.

**azumi** · 03-29-2016, 10:29 AM

Hope this works

**avk** · 03-30-2016, 05:29 AM

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.

**Khalidngo** · 03-30-2016, 05:47 AM

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,

**avk** · 03-30-2016, 06:01 AM

Yes Khalidngo. Thanks

Re: Sumifs Formula Not Working While two criteria & between two dates