How do I calculate?

G

Guest

Hi - how do I calculate a value from one column where the value in another
column contains a certain customer name?

For example: I want to know from my spreadsheet how much $$ that customer
"BabyChime" has paid for 2006. So I want a formula that will look for each
customer and the matching dollars.

My customer names are in column D and my dollars are in column J. Does this
make sense?

I was using this but it's not working.

=SUM(--(completed!D2:D181="BabyChime"),--(completed!J2:J181="*"))
 
J

JMay

Try:
=Sumif(completed!D2:D181,"BabyChime",completed!J2:J181)
Or
=Sumproduct(--(completed!D2:D181,"BabyChime"),completed!J2:J181)

HTH
 
M

MyVeryOwnSelf

Hi - how do I calculate a value from one column where the value in
another column contains a certain customer name?

For example: I want to know from my spreadsheet how much $$ that
customer "BabyChime" has paid for 2006. So I want a formula that will
look for each customer and the matching dollars.

One way is to use SUMIF. The csv file below is an example. Adapt as
needed.

A different way is to use a pivot table report. Look up "pivot table" in
Excel's built-in Help.

------------- cut here ----------
Customer,Amount,,Customer summary,Customer Total
BabyChime,6.36,,BabyChime,"=SUMIF(A:A,D2,B:B)"
YouthDesk,13.99,,YouthDesk,"=SUMIF(A:A,D3,B:B)"
BigFolks,26.84,,BigFolks,"=SUMIF(A:A,D4,B:B)"
BabyChime,41.9,,,
BigFolks,48.79,,,
YouthDesk,42.22,,,
BabyChime,38.72,,,
BabyChime,8.28,,,
BabyChime,25.44,,,
BigFolks,49.28,,,
YouthDesk,25.86,,,
YouthDesk,27.98,,,
YouthDesk,42.59,,,
BigFolks,31.97,,,

,,=SUM(B:B),<<<< should equal >>>>,=SUM(E2:E16)
 

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