Countif 2 conditions are meet and array

[Cameron]

Hello,

I am trying to count the number of occurrences in a table
of data that 2 conditions in the same row are meet. I
have been trying to use this function "=COUNTIF(AND
($B$2:$B$10000<100,$D$2:$D$10000="no date"))"

Any help is appreciated.

Cameron

 

[duane]

=sumproduct(($B$2:$B$10000<100*($D$2:$D$10000="no date")

 

[duane]

missed a )


=sumproduct(($B$2:$B$10000<100)*($D$2:$D$10000="no date"))

 

[Frank Kabel]

Hi
try:
=SUMPRODUCT(--($B$2:$B$10000<100),--($D$2:$D$10000="no date"))

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

 

[Frank Kabel]

Hi Duane
small typo (missing bracket): )
=sumproduct(($B$2:$B$10000<100)*($D$2:$D$10000="no date"))