Forum Discussion
MarkLGH1219
Mar 09, 2020Copper Contributor
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...
Savia
Mar 09, 2020Iron Contributor
You can make a formula like this one:
=COUNTIFS(course title column, "BTEC*", outcomes column, "Achieved")
=COUNTIFS(course title column, "BTEC*", outcomes column, "Achieved")
- MarkLGH1219Mar 10, 2020Copper Contributor
Savia Thank you very much, this really helped. My first post on a forum like this, really appreciate you helping out.