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!D2181="BabyChime"),--(completed!J2:J181="*"))
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!D2181="BabyChime"),--(completed!J2:J181="*"))