Exclude a specific cell from Total
Simply put: SUM(A1:A10) BUT Exclude A5 from sum of column.
Thanks for help-StowellNumbers
13.2 Ventura OS iPad
iMac 27″ 5K, macOS 13.6
Question marked as
=SUM(A1:A10) - A5
or
=SUM(A1:A4,A6:A10)
or use SUMIF if there is something special about that row that you can use as a condition in the SUMIF