Forum Home
Press F1
 
Thread ID: 3547 2000-02-09 22:48:00 Excel COUNTIF Guest (0) Press F1
Post ID Timestamp Content User
3973 2000-02-09 22:48:00 I am trying to contruct a formula to count the number of numbers between say 10 and 20 in a large range of numbers in order to contruct a frequency distribution using COUNTIF.

If I use a number in the condition part of the COUNTIF formula (say <10), the formula works. If I use a cell reference (say <F28) it does not work. Can anyone help me.
Guest (0)
1