SUMIF
 

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 Im using.



Name Sales SPH Productivity total

SUMIF
 

=SUMPRODUCT((productivityRange=90%)*(sphRange=0. 39),salesRange)
etc

Jerry

"TYE" wrote:



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 Im using.



Name Sales SPH Productivity total

SUMIF
 

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



--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"TYE" wrote in message
...


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