COMPARE AND COUNT VALUES

[Ron]

I have the high temperatures for the month in column B
and the average temperature for the date in column D. I
want to compare the high temperature in column B against
the average temperature in column D and count the
occurrences for the month where the high temperature
exceeded the average.

Thanks

 

[Frank Kabel]

Hi
one way (if your data starts in row 2)
=SUMPRODUCT(--(B2:B100>D2100))

 

[Bob Phillips]

Ron

Another way is to use FREQUENCY

Select a number of cells same as the number of average temperatures, and
enter
=FREQUENCY(B1:B1000,D150)
and enter as an array formula, Ctrl-Shift-Enter.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)