Averaging Text vs. Numbers
On Thu, 27 Apr 2006 07:30:02 -0700, NKDodd
wrote:
I have a column that we either enter “y” for yes or “n” for no to track
passing scores. Is there a way that I can average the yes’ and no’s from the
same column?
One way.
With scores in A1:A20 and y/n in B1:B10
Average of the y cells
=SUMIF(B1:B20,"y",A1:A20)/SUMPRODUCT((A1:A20<"")*(B1:B20="y"))
Average of the n cells
just change the y's to n's
HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
|