Krissy wrote:
Hi
I need a formula that will look in one column range for a certain value and
for another value in another column range and when they are both found in the
same row, will count the number of occurances. Help!!!!
http://www.contextures.com/xlFunctio...tml#SumProduct
Omit the "values to be summed".
=SUMPRODUCT(--(A2:A6="Active"), --(B2:B6=10))