| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to figure an average on a range of cells with an "if" form
I have a spreadsheet that has a formula in column g that is an "if" formula
for the data in column f. I need to get an average of the data in column "g". For example column f column g yellow 2 green 3 red 1 red 1 red 1 average yellow need formula for this help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| any formula to convert numbers in word form, e.g. "2" as "Two"? | Excel Worksheet Functions | |||
| function to return day in the form "Monday", "Tuesday" etc given . | Excel Worksheet Functions | |||
| Converting a text form of "=Sheet2!A1" into a reference formula | Excel Discussion (Misc queries) | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| Formula for % of "yes" in range of cells? | Excel Worksheet Functions | |||
Threaded Mode
