If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
If Formula question Excel 2003
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! |
#2
|
|||
|
|||
If Formula question Excel 2003
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! |
#3
|
|||
|
|||
If Formula question Excel 2003
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! |
#4
|
|||
|
|||
If Formula question Excel 2003
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! |
#5
|
|||
|
|||
If Formula question Excel 2003
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 |
Thread Tools | |
Display Modes | |
|
|