SUMIF ERROR

  • Thread starter Thread starter webone
  • Start date Start date
W

webone

I'm getting an error on a SUMIF function. Any idea on how to correct this
error? =SUMIF(D192,">25",E176*.0875) I'm trying to calculate a result in
cell D176 if the value of D192 is >25. If the answer is true for D192 then I
want Excel to take the value of E176*.0875. I have the SUMIF FUNCTION in
cell D176.
 
You need to put the *0.0875 outside the bracket, like this:

=SUMIF(D192,">25",E176)*0.0875

Another way, as you are not summing from a range, is:

=IF(D192>25,E176,0)*0.0875

Hope this helps.

Pete
 
Why SUMIF ? Change the 0 part below to whatever you want if D192 is not > 25

=IF(D192>25,E176*.0875,0)
 
Back
Top