View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default Variable reference in countif

Use INDIRECT:

=COUNTIF(INDIRECT("E6:E" & A1),"apples")

HTH,
Paul

--

"Libby" wrote in message
...
Hi there,

A1 contains a formula which gives a number, eg 127
How do I think incorporate this into a countif, eg
=countif( E6:E value in A1,"apples")

Many thanks.