Can I count values in column 1 if criteria in column 2 are met

[Aladin Akyurek]

=SUMPRODUCT(--(Range1<>""),--(Range2=Condition))

confounded office user Wrote:

 

[Ron Rosenfeld]

COUNTIF
--ron