software

I'd like to create a countif scenario where column A = Tech and Column C
lt;gt;0. I've seen other threads with references to Sumproduct... can I use
it in this scenario? Any help would appreciated....
A B C
industryTickerChangeCountCount of changes
TECHIBM0tech2
TECHDELL5Bank2
BANKCITI0
BANKSSB20

Thanks much.--
kwiklearner
------------------------------------------------------------------------
kwiklearner's Profile: www.excelforum.com/member.php...oamp;userid=31909
View this thread: www.excelforum.com/showthread...hreadid=527594
try
=sumproduct((a2:a33=quot;Techquot;)*(c2:c33lt;gt;0))

--
Don Guillett
SalesAid Software

quot;kwiklearnerquot; gt;
wrote in message
...
gt;
gt; I'd like to create a countif scenario where column A = Tech and Column C
gt; lt;gt;0. I've seen other threads with references to Sumproduct... can I use
gt; it in this scenario? Any help would appreciated....
gt; A B C
gt; industry Ticker Change Count Count of changes
gt; TECH IBM 0 tech 2
gt; TECH DELL 5 Bank 2
gt; BANK CITI 0
gt; BANK SSB 20
gt;
gt; Thanks much.
gt;
gt;
gt; --
gt; kwiklearner
gt; ------------------------------------------------------------------------
gt; kwiklearner's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31909
gt; View this thread: www.excelforum.com/showthread...hreadid=527594
gt;