Re: OR Function (MAYBE)

Giganews Newsgroups
Subject: Re: OR Function (MAYBE)
Posted by:  Bernie Deitrick (deitb…@ consumer dot org)
Date: Tue, 2 May 2006

Booner,

How about, say, in cell B2:

=COUNTIF($A$1:A2,B2)

or in cell B3

=COUNTIF($A$1:A2,B3)

Then copy down to match your list.

Which one to use depends on what you mean by above....

HTH,
Bernie
MS Excel MVP

"BOONER" <BOON…@discussions.microsoft.com> wrote in message
news:8CAF2E74-9ACF-4298-B9C6-767120D391…@microsoft.com...
> Basically I need to return the number of times a cell is equal to
> individual
> cells above it. Is there any way to count how many statements in an OR
> function are true? For example, given  OR(1+2=3,1+2=4,1+3=4)  returns 2.

Replies

None

In response to

OR Function (MAYBE) posted by Booner on Tue, 2 May 2006