I have 2 columns and I need the formula to read column "A" first and if it meets a certain criteria to look at column "B" and count if there's any text in the cells. See the example to show what I'm looking for. I would want the formula to look at column a for pet type (e.g. dog) and then look at owner's name (any text in that column gets counted) and give me the sum (in this case 3). I've tried a couple of things and I'm running out of time.
Example:
<colgroup><col><col></colgroup><tbody>
</tbody>
Thanks as always!
Example:
Pet Type | Owner's Name |
dog | |
dog | John |
dog | |
dog | Jane |
dog | Dan |
cat | Mollie |
cat | Mary |
cat | |
cat | Scott |
bird | George |
bird | |
fish | Bill |
fish | |
fish | Betty |
<colgroup><col><col></colgroup><tbody>
</tbody>
Thanks as always!
Last edited by a moderator: