average if

melvinm

Board Regular
Joined
Oct 27, 2005
Messages
152
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
 

melvinm

Board Regular
Joined
Oct 27, 2005
Messages
152
average

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

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
The month column, what exactly is entered there -- true dates, text such as Jan/Feb/etc ?
 

melvinm

Board Regular
Joined
Oct 27, 2005
Messages
152
thanks

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

melvinm

Board Regular
Joined
Oct 27, 2005
Messages
152
Month()

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

thanks
 

Forum statistics

Threads
1,078,373
Messages
5,339,814
Members
399,333
Latest member
Grace Ford

Some videos you may like

This Week's Hot Topics

Top