View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt S Matt S is offline
external usenet poster
 
Posts: 112
Default Is Sumproduct best for me?

I have at least 180,000 temperature data points that I need to break up into
a distribution curve. I essentially need to count the number of data points
between 100 and 105, then from 105 to 110, etc all the way until 495 to 500.

I'm currently using SumProduct, but attempts so far lead to 5+ min of
computation time. There has to be a better way! I obviously have
screenupdating off and all that jazz. Just wondering if sumproduct is right
for me.

Thanks,
Matt