Sum specific ranges in respective columns using SUM, SUMIF, and dynamic search functions like INDEX-MATCH or XLOOKUP.