ExcelBanter - EXCLUDE ADDRESSES IN A SERIES SUM

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - EXCLUDE ADDRESSES IN A SERIES SUM (https://www.excelbanter.com/excel-worksheet-functions/16862-exclude-addresses-series-sum.html)

viktaur

EXCLUDE ADDRESSES IN A SERIES SUM

how do i exclude addresses in a series sum function

JulieD

Hi

maybe
=SUM(A1:A1000)-SUM(A5:A10)

if this isn't what you're looking for if you could provide more details as
in the range to sum, the range(s) to exclude and the reason for their
exclusion maybe we can come up with a better solution.

Cheers
JulieD

"viktaur" wrote in message
...
how do i exclude addresses in a series sum function

All times are GMT +1. The time now is 05:42 PM.