I'm hoping some kind soul may be able to help me with an Excel calculation. I have provided a sample (http://www.filedropper.com/sample_16)
Basically it's a quotations database. Tab 'Q1' is the actual log, Tab 'Q2' is where the magic happens and the various formulas help build the analysis.
The part I need help on is follows;
I want to analyse the number of each quotations issued falling in to the specified value brackets per month. So it's like a count function by not only month, but only counting when it falls in to the value bracket criteria too. Way beyond my capability in Excel.
This will make more sense the moment you open the supplied sample file.
If by any chance the aforementioned kind soul can be any kinder, the ideal is not only the above, but actually return won, dead, lost and open counts for each month, for each bracket. Not sure if I'm being too ambitious with that request though!!
Basically it's a quotations database. Tab 'Q1' is the actual log, Tab 'Q2' is where the magic happens and the various formulas help build the analysis.
The part I need help on is follows;
I want to analyse the number of each quotations issued falling in to the specified value brackets per month. So it's like a count function by not only month, but only counting when it falls in to the value bracket criteria too. Way beyond my capability in Excel.
This will make more sense the moment you open the supplied sample file.
If by any chance the aforementioned kind soul can be any kinder, the ideal is not only the above, but actually return won, dead, lost and open counts for each month, for each bracket. Not sure if I'm being too ambitious with that request though!!
Last edited:
