ExcelBanter - Sum by format

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

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

- - Sum by format (https://www.excelbanter.com/excel-worksheet-functions/139607-sum-format.html)

GCC

Sum by format

I have just read a brilliant post on using a sumbold formula however I was
wondering if there was a way to do a formula to add all the values that
aren't in bold as well?

Thanks in advance!

Gary''s Student

Sum by format

Let's say you have a column of values from A1 thru A100 and you already have
the function SUMBOLD. What you want is:

=SUM(A1:A100)-SUMBOLD(A1:A100)
--
Gary''s Student - gsnu200716

"GCC" wrote:

I have just read a brilliant post on using a sumbold formula however I was
wondering if there was a way to do a formula to add all the values that
aren't in bold as well?

Thanks in advance!

GCC

Sum by format

Thanks! Simple but effective!

"Gary''s Student" wrote:

Let's say you have a column of values from A1 thru A100 and you already have
the function SUMBOLD. What you want is:

=SUM(A1:A100)-SUMBOLD(A1:A100)
--
Gary''s Student - gsnu200716

"GCC" wrote:

I have just read a brilliant post on using a sumbold formula however I was
wondering if there was a way to do a formula to add all the values that
aren't in bold as well?

Thanks in advance!

All times are GMT +1. The time now is 10:01 AM.