View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMay JMay is offline
external usenet poster
 
Posts: 468
Default How can you do COUNTIF between 3 spreadsheets

Sheetnames cannot contain the ":" character, at least my copy of excel will
not allow me to enter a : in a sheetname..


"chedd via OfficeKB.com" wrote:

Hi,

I am trying to find a value between 3 sheets to find a total o numvber of
British person who have accessed the service. The formula i am using is
=COUNTIF('Apr 07:Jun 07'!G27:G48,"British"), but all i am getting is a value
error.

--
Message posted via http://www.officekb.com