View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Count/if/and function?

=COUNT(A1:A123,"1")

Adjust range to suit.


Gord Dibben MS Excel MVP

On Tue, 25 Mar 2008 12:43:22 -0700 (PDT), tonyalt3 wrote:

I would like to count how many cells only IF they contain a value
greater than 1. Is this possible?