View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SisterDell SisterDell is offline
external usenet poster
 
Posts: 7
Default Please help me with a Conditional Count...

Frustrated Newbie...
What is wrong with the following formula I've created, if I'm trying to
count the number of occurrences in Column B that have 1's next to them AND
have either a "*" or a "Fw:*" in Column At?

A B
FYI 1
FYI 1
FYI
FW: FYI 1
Hi 1
FW: Hi 1

Formula:
=SUMPRODUCT((A1:A6="*")*(A1:A6="Fw*")*(B1:B6=1) )

I would expect to get back a value of 3. I'm getting 0 and no errors.

Thanks!