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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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")
 
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
 
Back
Top