Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Newbe Help with count/countif function
I'm trying to count the number of rows that fall within a numerical range. For example I want to count the number of rows that contain a value 5 and <=10 I tried both count and countif and keep getting errors. Half if it is no problem, =COUNTIF(E:E,"5") works as does =COUNTIF(E:E,"<=10") but when I put them together I have problems. I book uses the example {=SUM((E:E5)*(E:E<=10))} but that doesn't work either. Can someone point me in the correct location? Thanks! -- Cybertech ------------------------------------------------------------------------ Cybertech's Profile: http://www.excelforum.com/member.php...o&userid=26533 View this thread: http://www.excelforum.com/showthread...hreadid=398428 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |