GossemerCopper ContributorOct 08, 2020Help 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...Show MorePXL_20201008_125655747.jpg5.4 MB
Subodh_Tiwari_sktneerSilver ContributorOct 08, 2020Gossemer 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.
