Forum Discussion

Gossemer's avatar
Gossemer
Copper Contributor
Oct 08, 2020

Help with formula?

I'm trying to create a formula that can take several ranges of cells, calculate their sums separately, and then show the largest sum in the cell it's supposed to. I can't seem to figure it out. I took a quick picture before I got pulled away from that project.

Can someone help me figure it out?
excel
Formulas and Functions
training

2 Replies

  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Silver Contributor
    Oct 08, 2020

    Gossemer 

    In the screenshot, the whole formula is not visible but you may construct your formula as PReagan suggested like below...

     

    =MAX(F8,SUM(G8:H8),SUM(I8:M8),SUM(N8:R8),SUM(S8:W8),SUM(X8:AB8),SUM(AC8:AG8))

    You may add other ranges in the formula as required.

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Oct 08, 2020

    Hello Gossemer,

     

    Perhaps replacing the LARGE() function with MAX() will get you closer to your goal.

Resources