Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I perform a "Countif" function for Two Columns?
I am facing problem that I want to count number of occurances of a set of
text spread in Two Columns. For example, I have two columns A and B. In Column A, I have values F, B, L...In Column B, I have values F, M, N...Now I wish to know that how many occurances are there in which the value in Column A is "F" and Value in Column B, is "M". I hope I am able to convey my problem effectively. Please help me in this regard. |
#2
|
|||
|
|||
=SUMPRODUCT(--($A$2:$A$200="F"),--($B$2:$B$200="M"))
Syed Ali Zubair wrote: I am facing problem that I want to count number of occurances of a set of text spread in Two Columns. For example, I have two columns A and B. In Column A, I have values F, B, L...In Column B, I have values F, M, N...Now I wish to know that how many occurances are there in which the value in Column A is "F" and Value in Column B, is "M". I hope I am able to convey my problem effectively. Please help me in this regard. |
#3
|
|||
|
|||
Syed
One way: =SUMPRODUCT((A1:A100="F")*(B1:B100="M")) or if you put Text of column A in D1 and text of column B in E1: =SUMPRODUCT((A1:A100=D1)*(B1:B100=E1)) -- Best Regards Leo Heuser Followup to newsgroup only please. "Syed Ali Zubair" <Syed Ali skrev i en meddelelse ... I am facing problem that I want to count number of occurances of a set of text spread in Two Columns. For example, I have two columns A and B. In Column A, I have values F, B, L...In Column B, I have values F, M, N...Now I wish to know that how many occurances are there in which the value in Column A is "F" and Value in Column B, is "M". I hope I am able to convey my problem effectively. Please help me in this regard. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif function | Excel Worksheet Functions | |||
Perform functions on the result of adding two columns | Excel Worksheet Functions | |||
Advanced COUNTIF Function | Excel Worksheet Functions | |||
The countif function in Excel 2002. | Excel Worksheet Functions | |||
hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION | Excel Worksheet Functions |