Combining Data from Multiple Columns

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

How about in D1 you enter
M
In D2 you enter
N
And in D3 you enter
V

Then, enter this formula in E1, and copy down to E3:

=SUMPRODUCT(($C$1:$C$50=D1)*($A$1:$A$50<>0)*$A$1:$A$50)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JT" <JT@discussions.microsoft.com> wrote in message
news:0AD7F65E-05A9-44CC-84D3-3042B31E85BB@microsoft.com...
> 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

Made a mistake and added the donations for each group instead of counting
them.

Use this to count the groups:

=SUMPRODUCT(($C$1:$C$50=D1)*($A$1:$A$50<>0))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
news:O5FS0iIFGHA.2320@TK2MSFTNGP11.phx.gbl...
> How about in D1 you enter
> M
> In D2 you enter
> N
> And in D3 you enter
> V
>
> Then, enter this formula in E1, and copy down to E3:
>
> =SUMPRODUCT(($C$1:$C$50=D1)*($A$1:$A$50<>0)*$A$1:$A$50)
>
> --
> HTH,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
> "JT" <JT@discussions.microsoft.com> wrote in message
> news:0AD7F65E-05A9-44CC-84D3-3042B31E85BB@microsoft.com...
> > 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
>