Calculation of Data

Slicemahn

Board Regular
Joined
Jun 10, 2004
Messages
102
Hello,

Is there a way to display an input box that would used to compute the average?

For example, this is the layout of my data:

#of QCs Average Score
x ?

If the user inputs 5 for x, can I have an input box that would take five items and then average the scores as a result of what is inputted?

Thanks
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Gates Is Antichrist

Well-known Member
Joined
Aug 15, 2002
Messages
1,961
If you're going to use input box, then you'll be using VBA, right? It would be simple to just enter the values in a column (or row) and use AVERAGE, which works pretty "smartly."

For VBA, how about rather than trudging through a parsing of multiple input terms, have a loop like

Code:
Do
	sResponse=InputBox("Enter another term(just hit enter alone when done)", ,sResponse)
	dTotal = dTotal + sResponse
	iCount = iCount + 1
while sResponse <> ""
(etc.)
Error handling is strongly urged if this is to be distributed for others.
 

Slicemahn

Board Regular
Joined
Jun 10, 2004
Messages
102
Yes, I would have to use VBA, but this should work out nice. So error trapping would include the validation of the data being entered (ie. must whole numbers, no decimals, characters or alphabetized, symbols, etc). I got it. Many thanks.
Slice
 

Watch MrExcel Video

Forum statistics

Threads
1,122,217
Messages
5,594,887
Members
413,947
Latest member
gizmolucy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top