Hi All,
I am trying to calculate average for values in a range of data that fulfill a certain condition viz. >1000 & <=5000.
I am aware that the Averageif function can do the job, however I was unable to figure how to apply it in this particular case.
Any help on this is appreciated.
Thanks...