I am trying to teach myself Excel, but can's seem to get this formula to work.
I have a list that looks like this:
A B
Row1 0 3
Row2 2013 2
Row3 0 1
Row4 0 3
Row5 2012 0
I want to average the numbers in each column only if the number is <=3 and >=1 (so in column B average all the numbers except the 0 in row5). I also want colum A to return the number 0 or n/a if there are no numbers in that row <=3 and >=1.
I tried =IF(AND(G3:G8<=3,G3:G8>=1),AVERAGE(G3:G8),"0") but this is returning the value error. Any suggestions of how to make this work?? I can attach an example spreadsheet if it would be helpful.
Thanks!
Bookmarks