Question

Weather Tracker
Day of Month	Highest Temp	Weather Type
1	72	Sunny
2	67	Rain
3	62	Cloudy
4	42	Cloudy
5	40	Sunny
6	55	Rain
7	52	Cloudy
8	48	Rain
9	42	Sunny
10	44	Rain
11	52	Cloudy
12	57	Sunny
13	63	Sunny
14	65	Rain
15	74	Sunny
16	75	Sunny
17	55	Sunny
18	52	Rain
19	48	Cloudy
20	44	Rain
21	47	Sunny
22	45	Sunny
23	55	Cloudy
24	58	Rain
25	52	Sunny
26	50	Rain
27	44	Cloudy
28	40	Sunny
29	28	Snow
30	30	Snow
31	31	Snow
Average Temperature for the month		51.26
Highest Temperature		75
Number of Sunny Days		12
Number of Days above 70 Degrees
Number of Days at or below 60 degrees
Average Temperature of Rain Days
Average Temperature of a Snowy Day

What Formula would i use to answer the blank questions?

Answer 1

Let us suppose Day of the month is in COlumn A, Temperature in COlumn B and Weather Type in Column C. In Excel Type these formulas:

Number of Days Above 70 Degrees: =Countif(B:B,">70") This will count the number of days where temperature is above 70 degrees.

Number of Days at of below 60 Degrees: =Countif(B:B,"<=60")

Average Temperature of Rainy Days: =Averageif(C:C,"Rainy",B;B) This formula first searches for number of rainy days mentioned in column C and then for those values gives you average from column B.

Average Temperature of Snowy Days: =Averageif(C:C,"Snowy",B:B)