Database Sum using Multiple Criteria in Multiple Columns

Hi there,

I'm trying to use the dsum function, but am running into problems with the criteria. What I would like is for the function to add the footage (in column C)for each brand (column A), but also filter by brand category (column B).

So essentially, I'm trying to figure out the correct criteria to do this.

Here is what I have so far, but it returns the #NAME? error:

=DSUM(A5:C11,"Footage",((brand=MB AND Category=HB)))

Thanks for any help!

=SUMPRODUCT((A6:A11="MB")*(B6:B11="HB"),C6:C11) should work.

Originally Posted by darkyam

=SUMPRODUCT((A6:A11="MB")*(B6:B11="HB"),C6:C11) should work.

Great, thanks!