Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting based on values in two separate columns
Count the number of times in multiple rows that column a = sold and column b
= 1 Logically Count If A:A="sold" and b:b=1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting based on values in two separate columns
=SUMPRODUCT(--(A1:A1000="Sold"),--(B1:B1000=1))
Note with SUMPRODUCT you cannot use whole columns (i.e. A:A) "Wayne" wrote: Count the number of times in multiple rows that column a = sold and column b = 1 Logically Count If A:A="sold" and b:b=1 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting based on values in two separate columns
=SUMPRODUCT(--(A1:A100="sold"),--(B1:B100=1))
You can't use entire columns - A:A, B:B. Better to use cells to hold the criteria: C1 = sold D1 = 1 =SUMPRODUCT(--(A1:A100=C1),--(B1:B100=D1)) Biff "Wayne" wrote in message ... Count the number of times in multiple rows that column a = sold and column b = 1 Logically Count If A:A="sold" and b:b=1 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting based on values in two separate columns
Try this:
=SUMPRODUCT((A1:A100="sold")*(B1:B100=1)) That formula counts the instances where a Col_A value equals "sold" and the corresponding Col_B value is 1. Note: that formula is NOT case sensitive. Does that help? *********** Regards, Ron XL2002, WinXP "Wayne" wrote: Count the number of times in multiple rows that column a = sold and column b = 1 Logically Count If A:A="sold" and b:b=1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting based upon 2 conditions that are text based | Excel Discussion (Misc queries) | |||
comparing two columns of data to find common values | Excel Discussion (Misc queries) | |||
Copy columns values into separate columns | Excel Discussion (Misc queries) | |||
Counting based on values in two columns? | Excel Worksheet Functions | |||
Test IF Two Numeric Values Match (from two separate Dynamic Ranges) | Excel Worksheet Functions |