DaveTJDaniels
New Member
- Joined
- Dec 29, 2021
- Messages
- 2
- Office Version
- 2010
- Platform
- Windows
Hi,
I am trying to sum only hardcoded numbers in a column, and ignore any formulas.
I was hoping that the AGGREGATE function would do the job, but it only ignores subtotals.
Any help you can give would be much appreciated.
many thanks,
David
I am trying to sum only hardcoded numbers in a column, and ignore any formulas.
I was hoping that the AGGREGATE function would do the job, but it only ignores subtotals.
Any help you can give would be much appreciated.
many thanks,
David