March 2023 - CrispExcel Training & Consulting

How to SUMIF Data Ignoring Hidden Rows in Excel

by Crispo Mwangi | Mar 8, 2023 | ADVANCED EXCEL

SUMIF Data Ignoring Hidden Rows in Excel is not as simple as other types of summation using criteria. This is because the SUMIF function does not ignore hidden rows. The solution comes from using a combination of SUBTOTAL & OFFSET functions to return only visible...

How to SUMIF Data Ignoring Hidden Rows in Excel

Follow Us

Categories

Recent Posts

Recent Comments

Archives