I want to count number of rows which satisfy the conditions on two columns.
My Excell worksheet has data in 3 columns (A, B, C) and 20 rows.
First row is header/label row i.e. Name, City, Age .
Other rows contains data for several persons.
Now, I want to make summary of this database based upon the following condions (for example):
- count number of rows in column A if data in range A1:A20 contains/equal to "specific-name" AND data in range B1:B20 contains/equal to "specific-city"
I want to enter this "specific-name" in Cell E1 and "specific-city" in Cell E2. I want to get result in Cell E3.
Can anyone help me making this formula.