Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct with And? | Excel Discussion (Misc queries) | |||
SUMPRODUCT | Excel Programming |