Countif/And Function

From: "acyakos" <acyakos@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 10 May 2005 12:42:12 -0700

I am trying to count the number of occurrences in a column based on two
criteria. For example, I would like to count how many times the letter 'N'
appears in column E, but only if the value in column A is equal to 0016. Can
this be done using the COUNTIF or AND functions?? (basically I would like to
count the number of cells in column E with a value of N in column E AND a
value of 0016 in column A)

Hopefully this makes sense...

Thanks!
.

Follow-Ups:
- Re: Countif/And Function
  - From: Domenic

Prev by Date: Re: How do I merge the contents (separated by a comma) of 300+ cells?
Next by Date: RE: Subtotal Bug in Excel 2003
Previous by thread: Work*** - Functions from *** to ***
Next by thread: Re: Countif/And Function
Index(es):
- Date
- Thread