Hello

I have tried to us this formula but it returns a #NUM! value.

I am trying to count no sum the cells

Thanks
--
Cheers


"Aladin Akyurek" wrote:

=SUMPRODUCT(--($A$2:$A$100="Main"),--($B$2:$B$100="Yes"))

Joe wrote:
help I am trying to write a formula that says the following.

if coloum a = main and if coloum b = yes please count the yes's

I have tried using vlookup and count if but I just get a null value returned

hope there is somebody there who can help

thanks