View Single Post
  #1   Report Post  
mmock
 
Posts: n/a
Default Formula for counting specific cells which are greater than 1

I'm looking for a formula that will count specific cells (not a range - A17,
A27, A37 and so on) that will have a certain value (above $1.00 to make it
easy). So if the cell has a value of $1.00 or less it will not count in the
total; If it is above $1.00 if will count. If A17 is above $1.00, A27 is
$0.50 & A37 is $3.00 the count will be 2.