So a simple regression will be enough to determine up/down/stable? The SLOPE() function ignores blanks/text/boolean (see helpfile here: https://support.office.com/en-us/art...a-61d7e01276b9 ), so my first thought would be to simply use the SLOPE() function SLOPE(B2:Q2,$B$1:$Q$1) to get the slope. If this value is "negative" then the trend is down, if "positive" then trend is up, if "zero" then trend is stable. An IFERROR() could be used to trap the Div/0 error for the single entry rows. You would need to consider how close to 0 the slope gets before you decide something is truly 0, as floating point error and other noise in the data may cause some that you think should be 0 to return a non-zero result. I would suggest that you start with a SLOPE() function and fine tune it from there.