Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Number of arguments
Hi,
I am entering maximum temperatures each day and want to calculate the average of these temperatures. Not all days are available so I only want the average of those days when temperatures are available. All is fine when using =AVERAGEA in a month when there are 30 days, but when there are 31 Excel won't calculate this as the number of arguments is limited to 30 (I am calculating from data on Shet 1 to Sheet 2). Is there anyway to work around this? Thanks, Simon -- Weather Consultancy Services / Weather School The Weather Centre, 188 Common Road, Wombourne, South Staffordshire. WV5 0LT. Tel: 01902 895252 email: http://www.weatherweb.net http://www.weatherschool.co.uk http://www.atlanticweather.co.uk |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
doubling a number X number of times | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
How do I sort a column a unique number? | Excel Worksheet Functions |