Formula Help needed
=SUMPRODUCT(--(Date=--"2007-11-3"),--(Customer="John"),SalesDollars)
"Krish" wrote:
I have a table containing Date of Invoice, Customer #, Sales Dollars, Sales
Rep#. Using Sumproduct I was able to extract if the same customer has
multiple transactions on the same date. I am trying to get a sum of sales
dollars for a customer if there are more than one transaction. In other
words, if there are only one transaction, it will be the same dollar amount.
How do I write a formula?
|