Average only with specific critera

Giganews Newsgroups
Subject: Average only with specific critera
Posted by:  Stephen
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...

--
Thanks!

Stephen

Replies