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

--
Don Guillett
SalesAid Software

"kwiklearner"
wrote in message
...

I'd like to create a countif scenario where column A = Tech and Column C
<0. I've seen other threads with references to Sumproduct... can I use
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.


--
kwiklearner
------------------------------------------------------------------------
kwiklearner's Profile:
http://www.excelforum.com/member.php...o&userid=31909
View this thread: http://www.excelforum.com/showthread...hreadid=527594