Countif modification

[Brew]

how do I modify the following formula to count only the "M" cell records in z11:z40, which also have a numeric result on the same row in the V column.
=COUNTIF(Z11:Z40,"M")

 

[NBVC]

=SUMPRODUCT(--(Z11:Z40="M"),--ISNUMBER(V11:V40))

 

[Brew]

Thanks NBVC....The solutions works!

 

[Peter_SSs]

If I have understood correctly, this should work just as well:
=SUMPRODUCT(--(Z11:Z40="M"),V11:V40)

 

[Richard Schollar]

Peter

Surely that won't work as a count if the numeric results are anything other than 1s?

Richard

 

[Peter_SSs]

Peter

Surely that won't work as a count if the numeric results are anything other than 1s?

Richard

Absolutely correct Richard, I had mis-interpreted the post completely.