Thread: count 2 criteria text or numbers
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BNT1 via OfficeKB.com BNT1 via OfficeKB.com is offline
external usenet poster
  
Posts: 125
Default count 2 criteria text or numbers
Pete

Thats brilliant, the quotation marks were the sticking point, all working
fine
by the way, not sure if this should this be entered Ctl+Shift+Enter? it
working ok

thanks again

Pete_UK wrote:
Are you putting the 105 inside the quotes of test1 ?

If you have numbers in column B of your file, then you should not use
quotes.

Hope this helps.

Pete

Hi

[quoted text clipped - 15 lines]
--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200711/1

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200711/1

Reply With QuoteReply With Quote