Hi,
Thanks for your help on this one.
I'd like a formula that will add '1' when two criteria are met. Please see below example;
This is a sales tracking form. There are 3 jobs below that were quoted (and therefore 'active') in January and the column next to it, the month in which the quote was 'won'.
What I would like to happen is that in the 'summary' tab I have, if a job is ever marked as 'won', the total number of jobs appears in the relevant cell adjacent the relevant month (please see below). In this example, there should be a 1 in January and a 2 in February.
I hope this all makes sense and I appreciate any support you might be able to offer.
I look forward to hearing from you soon!
Thanks for your help on this one.
I'd like a formula that will add '1' when two criteria are met. Please see below example;
This is a sales tracking form. There are 3 jobs below that were quoted (and therefore 'active') in January and the column next to it, the month in which the quote was 'won'.
What I would like to happen is that in the 'summary' tab I have, if a job is ever marked as 'won', the total number of jobs appears in the relevant cell adjacent the relevant month (please see below). In this example, there should be a 1 in January and a 2 in February.
I hope this all makes sense and I appreciate any support you might be able to offer.
I look forward to hearing from you soon!