Forum Discussion
Calculations using a table
I have a spreadsheet that has 5 "courses", I need to calculate "revenue" based on percentage completed (weeks completed/total weeks). I have one table with student data including course name, weeks ...
you can use match, index, offset formulas to find whichever data you need from any row and any column.