This is often done using the sumproduct() function
=sumproduct(--(range1 = criteria 1),--(range2 = criteria 2))
the arrays in each section must be the same size but tcannot be the
shorthand for full columns. (A:A won't work)
the "--()" changes the logical true false to a numeric 1 0 for calulations

"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.