What is the proper syntax in Excel 2003 for the following:

If cells A6:A20="Tom" and cells B6:B20="a" then count the number of "a" in
cells B6:B20.

Thanks!

Try this:

=Sumproduct((A6:A20="Tom")*(B6:B20="a")*B6:B20)

--

HTH,

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

"Tom" wrote in message
...
What is the proper syntax in Excel 2003 for the following:

If cells A6:A20="Tom" and cells B6:B20="a" then count the number of "a" in
cells B6:B20.

Thanks!

Drop the last argument ! ! !

=Sumproduct((A6:A20="Tom")*(B6:B20="a"))
--

HTH,

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

"Tom" wrote in message
...
What is the proper syntax in Excel 2003 for the following:

If cells A6:A20="Tom" and cells B6:B20="a" then count the number of "a" in
cells B6:B20.

Thanks!

I assume you want to know the number of times
that both conditions are met.

=SUMPRODUCT((A6:A20="Tom")*(B6:B20="a"))


Greetings from New Zealand

"Tom" wrote in message
...
What is the proper syntax in Excel 2003 for the following:

If cells A6:A20="Tom" and cells B6:B20="a" then count the number of "a" in
cells B6:B20.

Thanks!

On Jan 5, 2:27*pm, "Bill Kuunders" wrote:
I assume you want to know the number of times
that both conditions are met.

=SUMPRODUCT((A6:A20="Tom")*(B6:B20="a"))

Greetings from New Zealand

"Tom" wrote in message

...



What is the proper syntax in Excel 2003 for the following:

If cells A6:A20="Tom" and cells B6:B20="a" then count the number of "a" in
cells B6:B20.

Thanks!- Hide quoted text -

- Show quoted text -

If you wish to count only the occurance of "a" in conlum B try
countif(B6:B20,"a").
If you need to tie "Tom" and "a" togeather so both conditions must be
met try =IF(AND(A6="TOM",B6="A"),"A","") placed in column C then use
the countif statement adjusted to column C.

Regards

BigD