I have this scenario

A B C D

1 John Susan $10
2 John John $10
3 Peter John $20
4 John Peter $0


What I want is easy I guess; but I don't know wich formula is the best.
I need to create a report that gives me all the differents scenarios for
example.

How many "John" in B are now in C ( I need just a number not a list)
How many "Johns" in B are still "John" in C
How much money a "john B Peter C" collect
A very important one how many names start with a "J"

The only problem is I have almost a hundred of differents columns, so is
impossible to do it manually and I need a report weekly so I was thinking
wich function is the best fit for this.

Any, ANY help or idea is welcome because I'm lost I have no idea how to do
it. Thank you in advance