Prev: Pulling out invoices that do not match
Next: In a formula, how do I set a maximum acceptable value?
From: bob on 5 Mar 2010 20:24
Column E2:E61 contains only numbers between -1 and 3. In E62, I want a
formula that will tell me the number of times both 0 and 2 appear in the
column.

Example
Column E
Row 2 0
Row 3 -1
Row 4 3
Row 5 -1
Row 6 2
Row 7 0
Row 8 1
etc.

In this example, the formula would return a value of 3 because 0 and 2
appear a total of 3 times.

Thanks,
Bob
From: T. Valko on 5 Mar 2010 21:02
One way...

=COUNTIF(E2:E61,0)+COUNTIF(E2:E61,2)

--
Biff
Microsoft Excel MVP


"bob" <bob(a)discussions.microsoft.com> wrote in message
news:453DB450-3F00-4DED-81FC-7E58755EAD0F(a)microsoft.com...
> Column E2:E61 contains only numbers between -1 and 3. In E62, I want a
> formula that will tell me the number of times both 0 and 2 appear in the
> column.
>
> Example
> Column E
> Row 2 0
> Row 3 -1
> Row 4 3
> Row 5 -1
> Row 6 2
> Row 7 0
> Row 8 1
> etc.
>
> In this example, the formula would return a value of 3 because 0 and 2
> appear a total of 3 times.
>
> Thanks,
> Bob


From: JLatham on 5 Mar 2010 21:32
for E62:
=SUM(COUNTIF(E2:E61,{0,2}))

Response inspired by Gord Dibben <g>.

"bob" wrote:

> Column E2:E61 contains only numbers between -1 and 3. In E62, I want a
> formula that will tell me the number of times both 0 and 2 appear in the
> column.
>
> Example
> Column E
> Row 2 0
> Row 3 -1
> Row 4 3
> Row 5 -1
> Row 6 2
> Row 7 0
> Row 8 1
> etc.
>
> In this example, the formula would return a value of 3 because 0 and 2
> appear a total of 3 times.
>
> Thanks,
> Bob
 | 
Pages: 1
Prev: Pulling out invoices that do not match
Next: In a formula, how do I set a maximum acceptable value?