=SUMPRODUCT(("rangea"="condition1)*("rangeb"="cond ition2")*("range to sum"))

Note all ranges must contain the same number of rows or columns.

With two columns of criteria and one column of data

=SUMPRODUCT(A1:A10="One")*(B1:B10=5)*(C1:C10))





"TimH" wrote in message
...
Is there a way to do SUMIF to sum a column of number based on meeting 2
independent conditions rather than 1. (i.e. checking independent values or
conditrions in 2 different cells.)