ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula for counting specific cells which are greater than 1 (https://www.excelbanter.com/excel-discussion-misc-queries/23560-formula-counting-specific-cells-greater-than-1-a.html)

mmock

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.



All times are GMT +1. The time now is 09:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com