SUMPRODUCT

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
 
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
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One for somebody 0
Finding the weighted average of text that have been given values 1
sumproduct producing #VALUE! 6
Help on a function with Conditional Formatting 0
Solving two equations with known exponent 5
Average If, with a Moving Target 0
SUMPRODUCT 3
Sumproduct formula help needed 6

Top