I am trying to compare and count data from multiple columns and return a
value to another column. For example:

Cells A1 through A50 will contain a donation amount from prospective donors
as donations are received.
Cells B1 through B50 identify the prospective donors by name
Cells C1 through C50 contain a single letter designation on the type of
donor ( M=member, N=non-member, V=visitor, etc...)

In E1 I want to be able to return the total number of members (M) who have
submitted donations by checking A1 through A50to see if there is any value in
each cell. In E2, the same but for non-members (n)...same in E3 for visitors
(V).

Is there a formula to accomplish this and can you guide me?

Thanks!

JT