software

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$50lt;gt;0)*$A$1:$ A$50)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;JTquot; gt; wrote in message
...
gt; I am trying to compare and count data from multiple columns and return a
gt; value to another column. For example:
gt;
gt; Cells A1 through A50 will contain a donation amount from prospective
donors
gt; as donations are received.
gt; Cells B1 through B50 identify the prospective donors by name
gt; Cells C1 through C50 contain a single letter designation on the type of
gt; donor ( M=member, N=non-member, V=visitor, etc...)
gt;
gt; In E1 I want to be able to return the total number of members (M) who have
gt; submitted donations by checking A1 through A50to see if there is any value
in
gt; each cell. In E2, the same but for non-members (n)...same in E3 for
visitors
gt; (V).
gt;
gt; Is there a formula to accomplish this and can you guide me?
gt;
gt; Thanks!
gt;
gt; JTMade 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$50lt;gt;0))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;Ragdyerquot; gt; wrote in message
...
gt; How about in D1 you enter
gt; M
gt; In D2 you enter
gt; N
gt; And in D3 you enter
gt; V
gt;
gt; Then, enter this formula in E1, and copy down to E3:
gt;
gt; =SUMPRODUCT(($C$1:$C$50=D1)*($A$1:$A$50lt;gt;0)*$A$1:$ A$50)
gt;
gt; --
gt; HTH,
gt;
gt; RD
gt;
gt; --------------------------------------------------------------------------
-
gt; Please keep all correspondence within the NewsGroup, so all may benefit !
gt; --------------------------------------------------------------------------
-
gt; quot;JTquot; gt; wrote in message
gt; ...
gt; gt; I am trying to compare and count data from multiple columns and return a
gt; gt; value to another column. For example:
gt; gt;
gt; gt; Cells A1 through A50 will contain a donation amount from prospective
gt; donors
gt; gt; as donations are received.
gt; gt; Cells B1 through B50 identify the prospective donors by name
gt; gt; Cells C1 through C50 contain a single letter designation on the type of
gt; gt; donor ( M=member, N=non-member, V=visitor, etc...)
gt; gt;
gt; gt; In E1 I want to be able to return the total number of members (M) who
have
gt; gt; submitted donations by checking A1 through A50to see if there is any
value
gt; in
gt; gt; each cell. In E2, the same but for non-members (n)...same in E3 for
gt; visitors
gt; gt; (V).
gt; gt;
gt; gt; Is there a formula to accomplish this and can you guide me?
gt; gt;
gt; gt; Thanks!
gt; gt;
gt; gt; JT
gt;