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

D

Dominic

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
 
J

JE McGimpsey

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")
 
S

swatsp0p

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
 
J

JE McGimpsey

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