SUMIF ERROR

[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.

 

[Pete_UK]

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

 

[RonaldoOneNil]

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

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

 

[Teethless mama]

=(D192>25)*E176*0.0875