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="*"))

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

HTH


"Tammy" wrote in message
:

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="*"))

Tammy

From your description, it would appear that a SUMIF could do it:

=SUMIF(completed!D2:D181,"BabyChime",completed!J2: J181)

Best regards

Richard



Tammy wrote:
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="*"))

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)

thank you both.

"RichardSchollar" wrote:

Tammy

From your description, it would appear that a SUMIF could do it:

=SUMIF(completed!D2:D181,"BabyChime",completed!J2: J181)

Best regards

Richard



Tammy wrote:
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="*"))

Have you tried a Pivot Table?

Regards.

Bill Ridgeway
Computer Solutions

"Tammy" wrote in message
...
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="*"))