Hi,

You may use array formulas (Ctrl+Shift+Enter) to get around your problem.

=sum(if((condition 1)*(condition 2), sum to range))

Regards,

Ashish Mathur

"savv32" wrote:

My question revolves around summing particular items in a column based upon
the number meeting 2 criteria. I have done this before with the sumif
function for one criteria and am wondering how to do this using 2 criteria.