Multiple Criteria & Count if Equals 0
Try
=SUMPRODUCT((A1:A10="Smith")*(B1:B10=0)*(B1:B10<" "))
If this post helps click Yes
---------------
Jacob Skaria
"slf" wrote:
Need help with a formula to find criteria in one column then count the number
of 0's in another.
Example:
col a col b
smith 2
jones 9
smith 0
rider 4
smith 0
smith 0
need the return for the number of 0's for smith
this would equal 3
using excel2007
help is much appreciated
|