Home |
Search |
Today's Posts |
#1
|
|||
|
|||
average if function
I need to average the cost per lb if a string starts with...my spread sheet
is 640 rows long with over 10 averages needed. I know how to do the formula except how to say "starts with" instead of "=" the string is quite long but I only need to reference the first part of it "tu or ana36" example below TU SQRPR INB000160032000384000000200000000 ANA36 BAR INB000160001600002000000200000000 ANA36 BAR INB000160001600004000000200000000 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using The Average Function if a cell has NA | Excel Worksheet Functions | |||
Average Function help | Excel Worksheet Functions | |||
How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions | |||
Average function with If | Excel Worksheet Functions | |||
Using Average function when number is zero | Excel Worksheet Functions |