Formula

[Denise]

I need to figure out what formula to use to count two different things in a row.

I will have rows that will have U and AU in some cells. At the end of the row I want it to add all of the U's and AU's.

Do I use a Count If formula and how does that work when you are having it count two different things.

Thanks.

 

[RagDyer]

Try either of these:

=COUNTIF(A1:Z1,"A")+COUNTIF(A1:Z1,"AU")

=SUMPRODUCT((A1:Z1="A")+(A1:Z1="AU"))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I need to figure out what formula to use to count two different things in a
row.

I will have rows that will have U and AU in some cells. At the end of the
row I want it to add all of the U's and AU's.

Do I use a Count If formula and how does that work when you are having it
count two different things.

Thanks.

 

[mzehr]

Hi Denise,
Assuming that the end of the row is in column G try:

=COUNTIF(A1:F1,"=AU")+COUNTIF(A1:F1,"=A")
HTH

-----Original Message-----
I need to figure out what formula to use to count two different things in a row.

I will have rows that will have U and AU in some cells.

At the end of the row I want it to add all of the U's and
AU's.

Do I use a Count If formula and how does that work when

you are having it count two different things.