can some one explain to me the count(if()) function??

[sokevin]

i got this array formula...

where e4:e86, aq6 and aq5 are dates

={COUNT(IF(($E$4:$E$86>=AQ6)*($E$4:$E$86<=AQ5),$E$4:$E$86))}


i understand it...

but how does it differ to say a

"countif" function?

can the above function be simplified

 

[Jim Rech]

The COUNTIF function can handle only one condition while yours has two.

=COUNTIF(E4:E86,">="&AQ6)

--
Jim Rech
Excel MVP
|i got this array formula...
|
| where e4:e86, aq6 and aq5 are dates
|
| ={COUNT(IF(($E$4:$E$86>=AQ6)*($E$4:$E$86<=AQ5),$E$4:$E$86))}
|
|
| i understand it...
|
| but how does it differ to say a
|
| "countif" function?
|
| can the above function be simplified?
|
|
| ---
| Message posted
|