Excel 2007 : Adding Rows of data

**grghhn** · 12-01-2009, 12:08 AM

I have a Column of data and I need to add all of the cells above a certain amount, and get an average.

I also need to do the opposite. Add all of the cells below a certain number, and get an average.

**D_Rennie** · 12-01-2009, 12:20 AM

Hello you can use sumif for this.
greater than 1 .... =SUMIF(A1:A22,">"&1)
less than 2 .....=SUMIF(A1:A22,"<"&2)

hope this helps
cheers

edit and get an average.

...=AVERAGE(IF(A1:A21>1,A1:A21)) edited using ctrl+shift+enter

**DonkeyOte** · 12-01-2009, 04:52 AM

If as implied you're using XL2007 you can make use of the new AVERAGEIF function, ie:

=AVERAGEIF(A1:A22,">0")

for multiple conditions see AVERAGEIFS