Average

[nainman]

I have to calculate the average of performance,
The spreadsheet has the % yield in far
left column, I want to get average of performace column for a range of
yield (say if yeild is between 2% and 3%). I am trying sumif and
countif but I have to use it twice and it becomes too complicated.

 

[Peter Atherton]

If you can not use Excels Average function you need to
post with more information

regards
peter