I utilize the below table to access various sales data. I have a separate file to calculate unique orders and totaling sales per month (each month has it's own tab). I copy this information from a master sales data file. What I would like to do is grab that information from the master file instead of copying each months worth data to a new file. For example I use this formula to see how many orders that are in that month. Some have multiple line items but it only counts that sales order number once.
=SUMPRODUCT((A3:A135<>"")/COUNTIF(A3:A135,A3:A135&""))
In the above example, the number of rows are fixed for the certain month i would be calculating.
So in the above formula example, I am trying to find out how many unique So_Nbr's there are but would like to use a date range with the dates in the Taken_Date column. There is more that I am trying to do, but I think if I can figure this out the rest should fall in line.
I have deleted information from the "Name" and "Desc" columns to protect the innocent.
I understand i may not have explained well so let me know if you have any questions.
Thanks in advance.
Dave
<tbody>
</tbody>
=SUMPRODUCT((A3:A135<>"")/COUNTIF(A3:A135,A3:A135&""))
In the above example, the number of rows are fixed for the certain month i would be calculating.
So in the above formula example, I am trying to find out how many unique So_Nbr's there are but would like to use a date range with the dates in the Taken_Date column. There is more that I am trying to do, but I think if I can figure this out the rest should fall in line.
I have deleted information from the "Name" and "Desc" columns to protect the innocent.
I understand i may not have explained well so let me know if you have any questions.
Thanks in advance.
Dave
<tbody> </tbody> |
<tbody>
</tbody>