If Formula question Excel 2003

[Tom]

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!

 

[RagDyeR]

Try this:

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

--

HTH,

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

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!

 

[RagDyeR]

Drop the last argument ! ! !

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

HTH,

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

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!

 

[Bill Kuunders]

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

 

[BIG D]

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








- 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