software

I am new to excel and want to find out what function to use.

I want excel to count how many times I put the a name in colum A and how may time I put the a word in colum S

Example:
If I put the name quot;Anniequot; in colum A1 and the word quot;Yesquot; in colum S1.

I only want it to count the total of times both the name annie and the word yes occor in the same line.

Any help would be great!
Hi!

Try this:

B1 = Annie
C1 = Yes

=SUMPRODUCT(--(A1:A100=B1),--(S1:S100=C1))

Biff

quot;BRIANquot; gt; wrote in message
...
gt;
gt; I am new to excel and want to find out what function to use.
gt;
gt; I want excel to count how many times I put the a name in colum A and
gt; how may time I put the a word in colum S
gt;
gt; Example:
gt; If I put the name quot;Anniequot; in colum A1 and the word quot;Yesquot; in colum S1.
gt;
gt; I only want it to count the total of times both the name annie and the
gt; word yes occor in the same line.
gt;
gt; Any help would be great!
gt;
gt;
gt; --
gt; BRIAN
That works great! Thank you!