Help with Countif

[kwiklearner]

I'd like to create a countif scenario where column A = Tech and Column
<>0. I've seen other threads with references to Sumproduct... can I us
it in this scenario? Any help would appreciated....
A B C
industry Ticker Change Count Count of changes
TECH IBM 0 tech 2
TECH DELL 5 Bank 2
BANK CITI 0
BANK SSB 20

Thanks much

 

[Don Guillett]

try
=sumproduct((a2:a33="Tech")*(c2:c33<>0))

--
Don Guillett
SalesAid Software
(e-mail address removed)
"kwiklearner" <[email protected]>
wrote in message
news:[email protected]...