I have a spreadsheet set up as follows:
Col A has Dates
Col B has production units
Col C has Energy Units
Etc

One row for every day of the year starting at row 2, through row 366.

What I want to do is sum the production and energy units for every day
that the production was greater than 5% of the average annual
production.

I have tried =COUNTIF($B$2:$B$366,AVERAGE($B$2:$B$366)*.05)
This results in error messages.

I tried using a seperate cell for the average,
E.g. cell B367 =AVERAGE($B$2:$B$366)*.05

Then using the wizard =COUNTIF($B$2:$B$366,B367)
changes to =COUNTIF($B$2:$B$366,"B367")
and the reference is not used.

What am I doing wrong?


--
DCSwearingen

Getting old, but love computers.
------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=560762