| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excluding 0s and blanks from a LINEST function
Hey Everyone,
I'm trying to get a linear regression function to work and am having a lot of difficulty. I need the function to do a linear regression (LINEST) of 2 columns of data, but I need it to exclude 0s and blanks in the data(this is where I'm stuck). I've tried some of the suggestions I've seen here for the SUM and AVERAGE functions but it doesn't seem to be working with LINEST. Help :( - Disco |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel needs feature to delete blanks when autofilter is used. | Excel Discussion (Misc queries) | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| How to get lowest value excluding blanks | Excel Worksheet Functions | |||
| Filling in blanks. | Excel Worksheet Functions | |||
Threaded Mode
