Can COUNTIF accept Multiple Criteria?

[jubi]

I need to create a COUNTIF formula that finds all values within a rang
that are greater than .150045, and less than or equal to .300089.
I've been trying the following:

COUNTIF(($aa$6:$aa$177>.150045")*("$aa$6:$aa$177<=.300089")

But no go.

Can anyone offer any guidance?

Thanks in advance....

Jub

 

[Frank Kabel]

Hi
use SUMPRODUCT for this. e.g.:
=SUMPRODUCT(--($aa$6:$aa$177>150045"),--($aa$6:$aa$177<=300089))

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[duane]

sumproduct(($aa$6:$aa$177>.150045)*($aa$6:$aa$177<=.300089)