average if

[melvinm]

hi,
I have month in one column, and sales in the other column, want to calculate the average, there are thosands of entries for each month. is it possible to find the average of say one particualr month.

Thanks in advance

 

[cfree36]

=sumif(range,month,range)/counif(range,month)

 

[melvinm]

average

at the moment i am using countif and sumif to get the average, is there a better way

 

[just_jon]

The month column, what exactly is entered there -- true dates, text such as Jan/Feb/etc ?

 

[melvinm]

thanks

that sounds good will give it try and let you know, thanks

 

[melvinm]

Month()

i have used a Month() to get a number so i have month number there

thanks

 

[melvinm]

Thanks

Works great!!!!!!, thanks lot.


cheers