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.