Excel Forum



Excel Magic Trick 419: Add Two Largest, But Skip Columns C & E


See how to add the two largest values in a range with the requirement that we skip columns C & E. See an array formula using the SUM, LARGE and COLUMN functions.
Response to Excel Array Formula Series #5: SUM 3 Largest Values





Got a Question? Ask it Here in the Forum.