help on AVERAGEIF formula

[URkidding]

I have a column of data that contains numbers from 0-500.

I would like to average the values of all numbers that fall between 60 and 242

I can average the numbers greater than 60 averageif(P2262, >60, P2262)

and the same for less than 242

I don't see how to include both <> in the same operation.

 

[Sawday]

To aid my own knowledge I did a few searches in Google and came across this which appears very similar. If I'm wrong do please say so and I'll try harder.

 

[URkidding]

Thanks Sawday - Here's what I came up with that works great

IF(SUM(P2356)=0,0,AVERAGEIFS(P2356,P2356,">31",P2356,"<242")÷30)

It calls a zero if all cells are zero and /30 to give me a monthly average

 

[URkidding]

should be P2colonP356 ...etc
don't know where the smiley face came from