Re: Countif/And Function

Thanks so much Domenic! That works perfectly and saves a lot of time.

"Domenic" wrote:

> Try...
>
> =SUMPRODUCT(--(A1:A100="0016"),--(E1:E100="N"))
>
> OR
>
> =SUMPRODUCT(--(A1:A100=G1),--(E1:E100=H1))
>
> ....where G1 contains your first criterion, such as 0016, and H1 contains
> your second, such as N.
>
> Hope this helps!
>
> In article <1F8323F6-8CB7-4696-BCE0-DE2E0A59190E@xxxxxxxxxxxxx>,
> "acyakos" <acyakos@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> > 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!
>
.

Relevant Pages

  • handling missing data
    ... One of the problems I have is that for some of the cells in AZ(or other ... how would I apply the condition if not in the criteria of DAVERAGE? ... "Ashish Mathur" wrote: ... because the countif is not counting the exact cells going into the sum. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Can I Use a Count Function for Text?
    ... =countifwill count the number of cells that match the criteria. ... Some cells contain the character "@" with a space ... "David Biddulph" wrote: ... CoutA and CountIF and cannot be able to get anything ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How do I set up a formula to count multiple items?
    ... Countif counts each instance of the criteria. ... you can either divide the total count by 2 or multiply that total count by ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: counting functions
    ... both COUNTIF / SUMPRODUCT are available in Excel 97 ... This function will count the number> of cells that meet your criteria. ... > "Frank Kabel" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Counting the number of "#N/A" errors
    ... Enter the TEXT value #N/A in some cells and try to use Countif. ... You can do this using the asterisk wildcard *: ... Will count the LOGICAL value TRUE even though the criteria argument is ... After manually looking through the entire worksheet I found 2 cells ...
    (microsoft.public.excel.worksheet.functions)