=SUMPRODUCT(--($A$2:$A$100=description),--($C$2:$C$100=equipment),($B$2:$B$100))
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Hope" wrote:

I have 3 columns...

A - defect description
B - number of defects
C - equipment

I am trying to sum the number of defects if both the defect description and
equipment match the criteria.

Thanks in advance!

Hope