I have a worksheet with lots of information on it. I have created a summary sheet which gathers information on for example:
How many clients we have
How many clients each instructor has
How many clients have completed their referral
How many clients where removed from scheme
How many clients are pending
All of this data has been collected, using formulas such as this one:
=COUNTIFS(ExerciseReferral!E3:E674,"Annette",ExerciseReferral!F3:F674,"Completed")
This is an example of how many Completed clients Annette has.
The total completed is the overall on the whole spreadsheet which is a few years - but I would like to find out the total completed from the new financial year (April 1st 2022).
Can anyone help with me the correct formula?
It would be good if I could just add to this one, as I am a bit of a newbie with Excel.
Thank you
How many clients we have
How many clients each instructor has
How many clients have completed their referral
How many clients where removed from scheme
How many clients are pending
All of this data has been collected, using formulas such as this one:
=COUNTIFS(ExerciseReferral!E3:E674,"Annette",ExerciseReferral!F3:F674,"Completed")
This is an example of how many Completed clients Annette has.
The total completed is the overall on the whole spreadsheet which is a few years - but I would like to find out the total completed from the new financial year (April 1st 2022).
Can anyone help with me the correct formula?
It would be good if I could just add to this one, as I am a bit of a newbie with Excel.
Thank you