|Subject:||Average only with specific critera|
|Date:||Fri, 19 May 2006|
Hi. I am trying to average a set of numbers but only if the number in the
column to the left is equal to 1. For example:
b1:b100 I have either the number 1, 2, 3, or 4,
c1:c100 I have percentages
I want to average only the percentages that have a 1 to the left of it in
the b column.
Thanks in advance...