Try this:
=SUMPRODUCT(--(A3:A80="D"),--(date_range>="2010-10-01"),--(date_range<="2010-11-01"),value_range) + Enter
Adjust date and value ranges.
Hello all!
My name is Oscar (Sweden) and I found this blog via google and have been a subscriber since then.
Excel is a powerful tool and this site is a fantastic resource!
I think my strength in excel is array formulas. I hope I can add some value to this forum.
/Oscar