Forum Discussion
HELP with a formula
Hi Everyone,
I'm trying to create a table to keep track of my courses and achievements/failures. I have the data on one sheet called 'learner tracker 2020' and I want to put this information on a different sheet, currently called 'sheet 2'.
I have two course titles in column F on 'learner tracker 2020' sheet. The course titles are 'BTEC....' and 'TQUK...'
I want to count the course title entries in this column as this informs me, how many people started each course. I want to see this information on 'sheet 2'
In column J on the same sheet, I have 'achieved', 'withdrawn' and 'file referred' as the entries for each learner. I want to know if there is a formula, so I could know how many people on 'BTEC...' had 'achieved', 'withdrawn' and 'file referred'
I hope I have explained my self well enough.
Any help would be appreciated
4 Replies
MarkLGH1219 Attached is a working example I created, similar to what Savia suggested.
Riny_van_Eekelen Thank you very much, very much appreciated. Both suggestions worked for me.
- You can make a formula like this one:
=COUNTIFS(course title column, "BTEC*", outcomes column, "Achieved")Savia Thank you very much, this really helped. My first post on a forum like this, really appreciate you helping out.
