Hi
Apologies if this has been asked before. I have an audit of test results.
Column A is names.
Row 1 is dates from 1st Jan to 31st Dec.
Pupils have test results on different dates, marks out of 100.
What I would like to do is count the number of results per student row within the last 14 days. Is there a COUNTIF(s), MATCH, HLOOKUP, MATCH -type formula I can use?
Thank you!!
S
Apologies if this has been asked before. I have an audit of test results.
Column A is names.
Row 1 is dates from 1st Jan to 31st Dec.
Pupils have test results on different dates, marks out of 100.
What I would like to do is count the number of results per student row within the last 14 days. Is there a COUNTIF(s), MATCH, HLOOKUP, MATCH -type formula I can use?
Thank you!!
S