Home |
Search |
Today's Posts |
#1
|
|||
|
|||
counting in one column when two expressions in two other columns are true
Hi Group
I am trying to count in one column when two other columns are true example: a b c 1 D E F 2 G H I 3 D J F I want to count colulm 'c' when 'a' is 'D' and 'c' is 'F' = 2 Can anyone help? Regards Henrik |
#2
|
|||
|
|||
try
=sumproduct((a2:a200="A")*(c2:c200="f")) -- Don Guillett SalesAid Software "Henrik" wrote in message ... Hi Group I am trying to count in one column when two other columns are true example: a b c 1 D E F 2 G H I 3 D J F I want to count colulm 'c' when 'a' is 'D' and 'c' is 'F' = 2 Can anyone help? Regards Henrik |
#3
|
|||
|
|||
One way:
=SUMPRODUCT(--(A1:A3="D"),--(C1:C3="F")) See http://www.mcgimpsey.com/excel/doubleneg.html for an explanation of the "--". In article , "Henrik" wrote: Hi Group I am trying to count in one column when two other columns are true example: a b c 1 D E F 2 G H I 3 D J F I want to count colulm 'c' when 'a' is 'D' and 'c' is 'F' = 2 Can anyone help? Regards Henrik |
#4
|
|||
|
|||
Thanks guys!
It's now working. rgds Henrik "Henrik" skrev i en meddelelse ... Hi Group I am trying to count in one column when two other columns are true example: a b c 1 D E F 2 G H I 3 D J F I want to count colulm 'c' when 'a' is 'D' and 'c' is 'F' = 2 Can anyone help? Regards Henrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a One Column Directory from Two Columns | Excel Discussion (Misc queries) | |||
Pivot Table combining multiple columns | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
How can I see column headings of hidden columns in Excel before u. | Excel Discussion (Misc queries) | |||
Nexsted if across 3 columns | Excel Worksheet Functions |