SumProduct Counts Blank Results

[Joe Gieder]

I have this formula =SUMPRODUCT(--('Priced BOM'!
$Y$3:$Y$999>=26)) and it's supposed to count how many
cell values are over 26, the problem is that if there is
no value in cell Yx and only the formula it counts this
as being over 26. Is there any way to accurately count
only the values over 26?

TIA for your help
Joe

 

[Frank Kabel]

Hi Joe
try
=SUMPRODUCT(('Priced BOM'!$Y$3:$Y$999>=26)*ISNUMBER('Priced
BOM'!$Y$3:$Y$999))
Frank

 

[JoeGieder]

Thanks Frank. I've been trying for what seems like
forever to solve this problem. I just need to learn more
of the functions and what and how you can add them
together.

Joe

 

[Frank Kabel]

Hi Joe
you're welcome. hope the formula now works for you
Frank

 

[Biff]

Hi Joe,

Or just use:

=COUNTIF('Priced BOM'!$Y$3:$Y$999,">=26")

Biff