| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 33017 | 2003-05-04 14:25:00 | Excel's simple average problem... | Kahawai_Chaser (166) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 141327 | 2003-05-04 14:25:00 | Hi... Currently working on a laboratory calculation worksheet for measuring moisture weight increases at work, but stumbling on the final average calculations. I want to calculate the average of the first occurrence of a number in adjacent columns from a range.The other entries, which occur in no particular order, are a mixture of numbers and text (eg. N/A below).(* are the required values I need calculated)... C1 C2 N/A N/A N/A N/A N/A 20* 40* 15 35 10 30 7 Average = 30 I want everything to appear in the range for observation and future comparisons, but only want the average of the first numerical occurences - (40,20) above. I suspect one approach is a mixture of the IF(Logical test, True, False) and ISNumber and ISText fuctions all nested together which I tried but got really confused...Even trying Excel's rather comprehensive help menu. Note: The above numbers and text are actually formula results based on the IF(Logical Test, True, False) where True returns the number, and False the N/A text from other cells. Help here in the provision of a formula(s) or a another approach would be great... Cheers... |
Kahawai_Chaser (166) | ||
| 141328 | 2003-05-04 21:16:00 | As far as Im aware, Excels VB formula doesnt support iteration, ie starting at the top of the list, IF(...) ELSEgo down one. If your input data isnt changing, then just use the average formula, and manually select the cells you want to reference. Iain |
Iain Walmsley (3372) | ||
| 1 | |||||