I need to create a formula against a row of figures that will sum only the top 5 subtotals of that given row. The row contains 8 subtotals in which I only need to sum the highest 5 figures not including the detail columns that add to a given subtotal. The 8 subtotals may have some identical figures as one or more subtotal figures that make up the top/highest five subtotals.
Can you recommend a formula that will only include the subtotal columns and sum the top 5 figures and if the 5th highest figure is also the 6th highest figure to ignore one of those in the Top 5.
Thank you,
Cozart
Can you recommend a formula that will only include the subtotal columns and sum the top 5 figures and if the 5th highest figure is also the 6th highest figure to ignore one of those in the Top 5.
Thank you,
Cozart