Thread: COUNTIF
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default COUNTIF

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