SUMPRODUCT

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

Can anyone tell me why this formula is giving me a fraction for the
result:

=SUMPRODUCT(--(J5:J23>=0.95),--(J5:J23<1.05),--(J5:J23))*100/
COUNTA(J5:J23)

J5:J23 are all percentages. J5 value is 96.67% the rest are all 100%
so I was expecting a result from the formula above of 100% instead I
get 99.82%.

When I check the formula out I see the SUMPRODUCT returns 18.966666667
rather than 19 that I would have expected.

Regards

Peter
 
Can anyone tell me why this formula is giving me a fraction for the
result:

=SUMPRODUCT(--(J5:J23>=0.95),--(J5:J23<1.05),--(J5:J23))*100/
COUNTA(J5:J23)

J5:J23 are all percentages. J5 value is 96.67% the rest are all 100%
so I was expecting a result from the formula above of 100% instead I
get 99.82%.

When I check the formula out I see the SUMPRODUCT returns 18.966666667
rather than 19 that I would have expected.

Regards

Peter
Click to expand...

Got it sorted now, I was summing the values in J5:J23 silly me.
 
Back
Top