Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have 10 textboxes that will contain values from 1-5. Not all the textboxes HAVE to contain a value, though. How do I write code that will consider all 10 textboxes and give me the average of only the textboxes with values in them? For example, say boxes 1,2,3,4,5 have values of 4,5,3,4,4 respectively. The average should show 4. But the next time boxes 1,3,5,7,9 have values 2,4,5,3,5 respectively. The average should show 3.8. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Computing the item age | Excel Worksheet Functions | |||
Computing Time from One Day to Another | Excel Discussion (Misc queries) | |||
COMPUTING TWO COLUMNS | Excel Worksheet Functions | |||
"Drop the lowest" in computing average | Excel Worksheet Functions | |||
eliminating #value when computing average | Excel Programming |