Between Formula

honeybun

New Member
Joined
Nov 17, 2004
Messages
30
Guys, having a brainless day today, I have a coloumn of figures and i need a standard formula which counts which cells are between a certain set of numbers i:e

=COUNTIF(JAN!L:L,"is between 0 and 4")

can't seem to get my head round it, any one able to help please?
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,112,798
Messages
5,542,562
Members
410,560
Latest member
1ndependent
Top