Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help needed
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help needed
Hi Krish
Try creating a Pivot Table. Place your cursor in your data tableDataPivot TableFinish On the new sheet where the PT skeleton appears, Drag Date to the Row area Drag Customer # to the Row area Drag Dollar Amount to the Data area you will now have all of your data summarised by date and dollar amount. You could drag Date tot he Page area, select any individual date and just see the results for that day. -- Regards Roger Govier "Krish" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum formula needed | Excel Discussion (Misc queries) | |||
Formula Needed | Excel Discussion (Misc queries) | |||
Formula help needed | Excel Worksheet Functions | |||
Formula Help Needed | Excel Worksheet Functions | |||
Formula Needed... | Excel Worksheet Functions |