calculating sum and average values for specific days only

S

Soccerboy83

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
 
S

Sean Timmons

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.
 
S

Soccerboy83

This worked out great, thank you very much.

Sean Timmons said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top