SumProduct using greater than

  • Thread starter Thread starter Jeff Goldstein
  • Start date Start date
J

Jeff Goldstein

I have the following formula

=SUMPRODUCT(('All Resource Plan'!$B$3:$B$42=Principal)*
('All Resource Plan'!D$3:D$42>0))

Where B3 to B42 on the all resource plan tab have a
variety of roles including principal.

On the same tab d3 to d42 is a range of numbers from -1 to
+1.

I need to sum all values associated with a role that are
greater than 0. I was using this formula with an =1 and
it worked fine, however when I changed it to >0 it no
longer works.

Any help would be appreciated.
 
First of all, you are counting not summing, secondly the formula works for
me.
If you want to sum use

=SUMPRODUCT(('All Resource Plan'!$B$3:$B$42="Principal")*('All Resource
Plan'!D$3:D$42>0),'All Resource Plan'!D$3:D$42)

it obviously won't matter if you want to sum >0 and there are only -1 0 and
1 but if you want to sum <0
it will matter since you'll get a positive result using your formula. That
might not answer what is failing
but it is certainly not the formula, most likely it's the data, maybe your
values are text? Also what
does not work? An error, computer exploded, expected a different result?
 
Of course...I didn't realize that I was counting as
opposed to summing. When I made the mod suggested it now
works (it is summing the values that I need).

thank you,

Jeff
 
Back
Top