I'm looking to create a monthly sales report based on brand and month.
I have done it in the past using a load of if statements checking for monthly totals and then adding up the coloumn.
But there must be an easier way.
I have 4 brands. so In january I want to find the sum of the quotes based on each brand.
'A' contains the date
'J' contains the brand - Say A, B C or D
'M' contains the quote value
I want to firstly count the number of enquiries per brand per mont. (these are all entries without a qoute value.
Then I want to count the number of quotes per brand month (these are the entries with a quote value)
The I want to find the total value of the quotes per brand . per month.
any help would be greatly appreciated.
I have done it in the past using a load of if statements checking for monthly totals and then adding up the coloumn.
But there must be an easier way.
I have 4 brands. so In january I want to find the sum of the quotes based on each brand.
'A' contains the date
'J' contains the brand - Say A, B C or D
'M' contains the quote value
I want to firstly count the number of enquiries per brand per mont. (these are all entries without a qoute value.
Then I want to count the number of quotes per brand month (these are the entries with a quote value)
The I want to find the total value of the quotes per brand . per month.
any help would be greatly appreciated.