Formula assistance needed

%3CLINGO-SUB%20id%3D%22lingo-sub-1446051%22%20slang%3D%22en-US%22%3EFormula%20assistance%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1446051%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20need%20a%20formula%20to%20combine%20all%20the%20numbers%20in%20a%20column%20if%20they're%20also%20in%20a%20row%20with%20specific%20text.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1446051%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1446174%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20assistance%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1446174%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F691404%22%20target%3D%22_blank%22%3E%40TheOnlyTails%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20was%20good%20of%20you%20to%20post%20your%20file%2C%20but%20you%20left%20some%20threads%20dangling%20in%20your%20question%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EWhat%20numbers%2C%3C%2FLI%3E%3CLI%3Ewhat%20column(s)%2C%3C%2FLI%3E%3CLI%3Ewhat%20row(s)%3C%2FLI%3E%3CLI%3Ewhat%20specific%20text%3F%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1446924%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20assistance%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1446924%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20The%20numbers%20in%20the%20%22points%22%20column%3C%2FP%3E%3CP%3E2.%20See%201%3C%2FP%3E%3CP%3E3.%20If%20the%20number%20in%20the%20%22points%22%20column%20(for%20example%20-%20B2)%20is%20in%20the%20same%20row%20as%20one%20of%20the%20rankings%20(letter)%2C%20I%20need%20to%20get%20it%2C%20and%20all%20of%20the%20number%20with%20the%20same%20ranking%2C%20and%20sum%20them%20up.%3C%2FP%3E%3CP%3E4.%20The%20rankings%20in%20the%20%22level%22%20column%20and%20the%20M%20or%20C%20in%20the%20%22section%22%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1446999%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20assistance%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1446999%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F691404%22%20target%3D%22_blank%22%3E%40TheOnlyTails%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhy%20PivotTable%20in%20Sheet1%20doesn't%20work%20with%20you%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1447009%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20assistance%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1447009%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBecause%20that%20isn't%20a%20formula.%20That's%20a%20number%20I%20have%20to%20update%20by%20hand.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1447028%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20assistance%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1447028%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F691404%22%20target%3D%22_blank%22%3E%40TheOnlyTails%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20prefer%20to%20avoid%20Refresh%2C%20that%20could%20be%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197104i7ED7D13120B23EAE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eor%20bit%20more%20compact%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSUM(SUMIFS(Courses%5Bpoints%5D%2CCourses%5Blevel%5D%2C%24D4%2CCourses%5BSection%5D%2C%7B%22M%22%2C%22C%22%7D))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I need a formula to combine all the numbers in a column if they're also in a row with specific text.

5 Replies
Highlighted

@TheOnlyTails 

 

It was good of you to post your file, but you left some threads dangling in your question:

 

  1. What numbers,
  2. what column(s),
  3. what row(s)
  4. what specific text?
Highlighted

@mathetes 

1. The numbers in the "points" column

2. See 1

3. If the number in the "points" column (for example - B2) is in the same row as one of the rankings (letter), I need to get it, and all of the number with the same ranking, and sum them up.

4. The rankings in the "level" column and the M or C in the "section" column.

Highlighted

@TheOnlyTails 

Why PivotTable in Sheet1 doesn't work with you?

Highlighted

@Sergei Baklan 

Because that isn't a formula. That's a number I have to update by hand.

Highlighted

@TheOnlyTails 

If you prefer to avoid Refresh, that could be

image.png

or bit more compact

=SUM(SUMIFS(Courses[points],Courses[level],$D4,Courses[Section],{"M","C"}))