Trouble working with the MEAN function

  • Thread starter Thread starter yitbos
  • Start date Start date
Y

yitbos

I’d like to thank everyone in advance for reading this and trying t
help me out. I’m working on an excel file that will calculate the mod
for entries in any particular month.

I have six columns, we’ll call them B, C, D, E, F and G. Of eac
survey we get back, the student rates our performance from a 5 to 1 i
each of the columns B – F. Column G is simply the month of the yea
(i.e. 1=Jan, 12=Dec).

I have been able to calculate the average for January by using th
following statement:
=IF(COUNTIF(G:G,1)<1,"",(SUMIF(G:G,1,B:B)/(COUNTIF(G:G,1))))
This looks at column G and says if G has a 1 in it (which stands fo
January) then sum everything in column B that corresponds with th
January tag in column G and divide it by the count of all the item
that have a 1 in it from column G. We are trying to provide ou
instructors with an overall picture of how they are doing and a pe
month breakdown. However, we can’t have separate entries for eac
month as we have too many instructors for that.

In using the MODE command, I can’t find a way to calculate the MODE o
just the January items. MODE basically only lets you look at a rang
of values, for example: MODE(B6:B12000).

If anyone can suggest a way I can get a MODE calculation out of jus
the January items, I would greatly appreciate it. Thanks again.

John
(e-mail address removed)
 
You could Data>Filter>Autofilter the column with dates, with a Custom
criteria of Greater than
1/1/2004 and Less tThan 2/1/2004. Use the MODE function on the visible
cells.
--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
yitbos said:
I'd like to thank everyone in advance for reading this and trying to
help me out. I'm working on an excel file that will calculate the mode
for entries in any particular month.

I have six columns, we'll call them B, C, D, E, F and G. Of each
survey we get back, the student rates our performance from a 5 to 1 in
each of the columns B - F. Column G is simply the month of the year
(i.e. 1=Jan, 12=Dec).

I have been able to calculate the average for January by using the
following statement:
=IF(COUNTIF(G:G,1)<1,"",(SUMIF(G:G,1,B:B)/(COUNTIF(G:G,1))))
This looks at column G and says if G has a 1 in it (which stands for
January) then sum everything in column B that corresponds with the
January tag in column G and divide it by the count of all the items
that have a 1 in it from column G. We are trying to provide our
instructors with an overall picture of how they are doing and a per
month breakdown. However, we can't have separate entries for each
month as we have too many instructors for that.

In using the MODE command, I can't find a way to calculate the MODE of
just the January items. MODE basically only lets you look at a range
of values, for example: MODE(B6:B12000).

If anyone can suggest a way I can get a MODE calculation out of just
the January items, I would greatly appreciate it. Thanks again.

John
(e-mail address removed)



------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top