Forum Discussion
Help with a formula please
hello smart people. Gemini Advanced (ai) couldn't figure this out so I'm hoping you can... There is a file called 'SCWI Tracker - WIP.xlsx' with a tab labelled 'Course Data' containing many colu...
I think you can do:
=SUM( ([SCWI Phase]=28)*([EDCS & Name]="2.101 SCWI College Delivered")*[Term Seats Day 10]*[Benchmark ($)] )
to enter the formula I would enter it in the sheet you want it and click on the top of each table column (the table header not the column header) so Excel auto inserts the proper column reference with sheet name and table name and all.