Combining Data from Multiple Columns

G

Guest

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
 
R

Ragdyer

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)
 
R

Ragdyer

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top