Forum Discussion

poddm's avatar
poddm
Copper Contributor
Feb 04, 2025

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 columns. The ones I will need for the formula are as follows:

Col B = SCWI Phase

Col E = EDCS & Name

Col L = Term Seats Day 10

Col M = Benchmark ($)
If you need the table name, its CourseData.

I'll be writing the formula from a completely separate excel file on a different sharepoint group under my employer's microsoft 365 enterprise account (my excel version). Here's a visual:

For SCWI Phase 28 and EDCS & Plan Code 2.101 SCWI College Delivered, I want to I want to calculate the total revenue by multiplying each row's Term Seats Day 10 by its Benchmark ($).

Any help you can provide will be greatly appreciated.

Formulas and Functions
  • poddm's avatar
    poddm
    Copper Contributor
    Feb 07, 2025

    Thanks so much Martin... that worked 🙂

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Feb 04, 2025

    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.

Resources