| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating sum and average values for specific days only
This worked out great, thank you very much.
"Sean Timmons" wrote: so, your date will be in, say, Sheet2!A2 and the below table is in Sheet1 in B2, =SUMIF(Sheet1!$A$2:$A$10000,A2,Sheet1!$B$2$B$10000 ) gives sum of Max Temp. =SUMIF(Sheet1!$A$2:$A$10000,A2,Sheet1!$B$2$B$10000 )/COUNTIF(Sheet1!$A$2:$A$10000,A2) Gives Average of Max Temp. "Soccerboy83" wrote: i am currently have a list of alot of weather data, what i want to do is calculate the sum and average for the data collected on a certain day. For example i have 4 columns of values, 48 values for each day for a total of 12 months, so alot of numbers. Anyway what i want to do is have a formula that will calculate the sum and average values i need according to the date i specify (and only that date). Is there anyway i can do this, i seriously have tried everything, and am so lost. Example Date: Max. Temp. Min. Temp. Wind Speed Humidity 1/1/09 47 22 4.7 x 1/1/09 48 19 5.0 x 1/1/09 49 21 1.0 x ... ... ... 12/31/09 55 17 2.2 x 12/31/09 56 15 1.7 x 12/31/09 54 23 1.3 x |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating specific increments of time across days | Excel Worksheet Functions | |||
| How do I average a formula without calculating zero values? | Excel Discussion (Misc queries) | |||
| Calculating for number of days when values are in dates | Excel Worksheet Functions | |||
| Calculating Average Values Using Arithmetic Equations | Excel Worksheet Functions | |||
| Calculating Average Values Using Arithmetic Equations | Excel Worksheet Functions | |||
Hybrid Mode
