Sum by format

G

GCC

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!
 
G

Gary''s Student

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)
 
G

GCC

Thanks! Simple but effective!

Gary''s Student said:
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)
Click to expand...
 
Top