Thread: Count/if/and function?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default Count/if/and function?
If your cells are in column A, then try this:

=COUNTIF(A:A,"1")

Hope this helps.

Pete

On Mar 25, 7:43*pm, tonyalt3 wrote:
I would like to count how many cells only IF they contain a value
greater than 1. *Is this possible?

Reply With QuoteReply With Quote