Thread: Counting multiple values (including blanks) in one column
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Counting multiple values (including blanks) in one column
Refinement, closer interp on this line
does not include the word "bob" ..
implies that "bob" could be part of a text string in col B

Try in D2:
=SUMPRODUCT((A2:A10="Fred")*(ISERROR(SEARCH("bob", B2:B10))*((C2:C10="AA")+(C2:C10=""))))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply With QuoteReply With Quote