Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
wrote:
Col A Col B 11 1 11 1 12 1 11 2 13 2 11 1 I need a answer of three. If column a =11 i need it to count column b [...] using excel 2010. You need to count __what__ in column B when column A is 11? I am guessing you want to count when B is 1, since you expect 3 to be the answer. If you not require Excel 2003 compatibility, try: =COUNTIFS(A1:A6,11,B1:B6,1) If you require Excel 2003 compatibility (saving the file as ".xls"), try: =SUMPRODUCT((A1:A6=11)*(B1:B6=1)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I count the number of time 2 columns meet my criteria | Excel Discussion (Misc queries) | |||
COUNT using 2 different criterias | Excel Discussion (Misc queries) | |||
count pieces of records meet conditions in different columns | Excel Worksheet Functions | |||
How do I count 2 columns of data that meet a certain criteria? | Excel Discussion (Misc queries) | |||
count rows that meet two criteria in two different columns? | Excel Worksheet Functions |