Countif re: a Variable Cell Value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jack - 21 Jun 2006 10:00 GMT

How can I do a countif check where the value is a variable and held in
another cell?
i.e.

A1 = Average(E1:E70)

In B1 I want to count how many cells in the [constantly changing] range
E1:E70 are above average and have tried
=Countif(E1:E70,">a1") but B1's value remains at 0

TIA
Jack

Reply to this Message

Ardus Petus - 21 Jun 2006 10:05 GMT

=countif(e1:e70,">"&A1)

HTH
--
AP

> How can I do a countif check where the value is a variable and held in
> another cell?
[quoted text clipped - 8 lines]
> TIA
> Jack

Reply to this Message