How do you sum just values that are bold in a list of values?
 

I have a list values and some of the values are bold based on conditional
formatting. How do I sum only the values that are bold within the list of
values.

Thanks

Enter a SUM or SUMIF formula that uses the same conditions as your CF.
For instance, if your CF is "greater than 10" for A1:A10, then use

=SUMIF(A1:A10, "10")



In article ,
"Dominic" wrote:

I have a list values and some of the values are bold based on conditional
formatting. How do I sum only the values that are bold within the list of
values.

Thanks

One solution would require VBA to analyse the font in each cell.

Another would be to use the same critera in a sumif funtion that is
being used in the Cond. Format. e.g. if your Bold CF is based on
numbers =2 and <4 then:

=SUMIF(J3:J6,"=2")-SUMIF(J3:J6,"=4") would work, returning the total
of all values =2 and <4.

Good Luck

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=466036

Unfortunately, there's no access in VBA to the conditionally formatted
font.

In article ,
swatsp0p
wrote:

One solution would require VBA to analyse the font in each cell.