SUMIF

[Guest]

I need a I sum for the following,

If they get the following they will get £5 per sale,

Productivity =>90%
SPH =>0.39

If they get the following they will get £2.50 per sale

If productivity is less then 90%
SPH=> 0.39

If they get the following they will get £0.00
Productivity is less then 90%
Sph is less than 0.39

Or

Productivity is => 90%
SPH is less then 0.39


Can you help?

The below is the template I’m using.



Name Sales SPH Productivity total

 

[Guest]

=SUMPRODUCT((productivityRange=>90%)*(sphRange=>0.39),salesRange)
etc

Jerry

 

[Bob Phillips]

=IF(SPH<.39,0,IF(Productivity<90%,2.5,5))



--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)