sumif col 1 true & col2 true sum col3 matches

[larper]

Sometimes it doen't pay to come back from lunch. However it is Friday so we may have a chance.

Any ways I need to sum up freigh Cost in col3, when col 1 & col2 are ture to conditions.

And oh by the way I need to Count this also.

Any help? Thanks?

 

[Marq]

try this...this is a set up i have that does what i think your trying to do

first one adds your two conditions:

=sumproduct((A1:A56=90316469)*(B1:B56="D")*(C1:C56))
columns A nd B are your criteria columns...column C has the values u want sum'ed up

for the count try this:

=sumproduct((A1:A56="D")*(A1:A56="D")*(B1:B56=90316469)*(B1:B56=90316469))

of course i filled the columns in with my own criteria...just replace my columns and criteria with yours and all should work well

u may have to add quotes to the numbers for example "90316469"....or '90316469'

anyway..let me know if this works

Marq