Thread: Variable reference in countif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Libby Libby is offline
external usenet poster
  
Posts: 151
Default Variable reference in countif
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.
Reply With QuoteReply With Quote