Re: Countif/And Function

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

  • Re: Countif/And Function
    ... >> criteria. ... >> this be done using the COUNTIF or AND functions?? ... >> count the number of cells in column E with a value of N in column E AND a ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Countif/And Function
    ... I am trying to count the number of occurrences in a column based on two ... criteria. ... count the number of cells in column E with a value of N in column E AND a ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Why does a sumif use double speech marks
    ... Range is the range of cells you want evaluated. ... Criteria is the criteria in the form of a number, expression, or text ... > I have created a sumif formulas as follows: ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • SUM if with 3 criteria
    ... For some reason the ... Criteria doesn't work? ... Could it be that the cells in Input!K2:K1000 column have formulas in them? ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Further help on delete criteria found
    ... Bob helped me with some code to find and delete criteria found but i ... In filter 22, column V, i must find all the cells with #N/A in and clear ... all cells in columns V to AB. ... Prev by Date: ...
    (microsoft.public.excel.programming)