Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two COUNTIFs
I can use COUNTIF to determine the number of times a name shows up in a
column. I want a formula that will determine the number of times that a certain name in a row also has a lower case x in another column in the same row. I cannot figure out how to use two COUNTIFs in the same formula. Thank you for your help. -- Russell |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two COUNTIFs
Use SUMPRODUCT(), it can handle multiple columns and multiple criteria:
=SUMPRODUCT(--(A1:A1000="James"),--(B1:B1000="x")) See: http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- Gary''s Student - gsnu200800 "Russell" wrote: I can use COUNTIF to determine the number of times a name shows up in a column. I want a formula that will determine the number of times that a certain name in a row also has a lower case x in another column in the same row. I cannot figure out how to use two COUNTIFs in the same formula. Thank you for your help. -- Russell |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two COUNTIFs
I have searched various other emails about COUNTIFs and find that the
following formula works: =SUMPRODUCT(--(Jun_2008!E$2:E$20=A4),--(Jun_2008!K$2:K$20="x")) -- Russell "Russell" wrote: I can use COUNTIF to determine the number of times a name shows up in a column. I want a formula that will determine the number of times that a certain name in a row also has a lower case x in another column in the same row. I cannot figure out how to use two COUNTIFs in the same formula. Thank you for your help. -- Russell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIFS Function | Excel Worksheet Functions | |||
Countifs Fx in 07 how in 03? | Excel Discussion (Misc queries) | |||
Question about COUNTIFS | Excel Worksheet Functions | |||
countifs | Excel Discussion (Misc queries) | |||
2 COUNTIFS | Excel Discussion (Misc queries) |