| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
any suggestions?
using this formula =(AVERAGE(IF(ISNUMBER(G20),G20)+(IF(ISNUMBER(M20), M20)))) My G20=62.5 and my M20=30...... My formula gives me 92.5, but i want the average not the total.. why won't average work here? Keep in my sometimes when G20=NUMBER, M20=#DIV/0!, so that is why i have "isnumber" in there.. Help.. -- fivermsg ------------------------------------------------------------------------ fivermsg's Profile: http://www.excelforum.com/member.php...o&userid=32348 View this thread: http://www.excelforum.com/showthread...hreadid=521141 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Suggestions Suggeston, & Conditional Formatting | Excel Discussion (Misc queries) | |||
| Trying to match a text string to a data table, any suggestions? | Excel Worksheet Functions | |||
| Suggestions on possible chart | Charts and Charting in Excel | |||
| I can't navigate my sheet with my arrow keys. suggestions? | Excel Discussion (Misc queries) | |||
| Looking for Someone to review and make suggestions | Excel Discussion (Misc queries) | |||
Threaded Mode
