SumProduct Counts Blank Results

  • Thread starter Thread starter Joe Gieder
  • Start date Start date
J

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
 
Hi Joe
try
=SUMPRODUCT(('Priced BOM'!$Y$3:$Y$999>=26)*ISNUMBER('Priced
BOM'!$Y$3:$Y$999))
Frank
 
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
 
Back
Top