#### nicknicknickandnick

##### New Member

- Joined
- Apr 29, 2002

- Messages
- 29

I want to make formulas that don't just simply count how many cells in a range have A, B, or C (I know how to do that). Rather, I want to make, for example, a formula that counts how many A cells there are in a range, but only counts the A cells for the cells whose column number divided by row number is a result less than 1. (I also want formulas to count such cells with results equal to 1 and greater than 1.)

If I used COUNTIF($A$1:$J$10,AND("A",COLUMN()/ROW()<1)), the result is zero because the column and row functions are referencing the cell that the COUNTIF function is in rather than each of the cells in the desired range. Because the column and row functions only refer to the cell that the COUNTIF function is in, I can't count the cells I want.

Any formula ideas?