You used words in your database, are these the labels of codes (for example 1 = booked and 2 = cancel)?
If you have not used codes, I would do so first. Its very hard to make computers run formulas if they are not in numbers.
Most programs wont allow you too do so anyways.
If you code booked / cancel/ what other you have in numbers 0,1,2 and do the same for finances 0=no 1=yes for example.
Then select cases that meet both criteria (select cases > when criteria is satisfied > booked =0 & finances= 1, btw thats an example of course depending on the number you actually choose)
You can then split the file on the criteria 'month'.
Then you can do whatever you like, count, find avarage per month, etc etc.
I find this very hard to explain in english.
However for running stuff like this... these kind of things are very easy to do in spss, i find that much easier to use then exel.If you only need this answer, I could probably do it for you in 1 minute if you sent me the database.
(I hope you understand my point, I mean you should not make a formula, but should make a selection criteria and then split or aggregate based on month depending on if you want absolute or relative numbers)
Really dont use exel for this... if you dont have spss i believe microsoft office has another program for databases, I dont know what it is called. Otherwise get it spss from somewhere and import the database in there. Then you'll find what you look for very easily. I only use exel for my graphs not for any statistics really.
I hope this made any sense. x
|
