Help with excel formula?

Here is an example with what I'm working with.

....................Column......

.......................D..........

Row....1......John Doe

..........2 .....Jane Doe

..........3......John Lance

So I need to put a formula in row 4 that will say how many # of John's there are.

1 Answer

Relevance
  • 1 decade ago
    Favorite Answer

    =SUMPRODUCT(( ISNUMBER( SEARCH("John", D1:D3))) * (1))

    • Login to reply the answers
Still have questions? Get your answers by asking now.