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

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

confounded office user Wrote:



--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=276543

On Tue, 9 Nov 2004 03:39:03 -0800, "confounded office user" <confounded office
wrote:

COUNTIF
--ron