Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sum if Color Blue (2002)

    I have a column of numbers. Part are imported and the blanks are manually entered in blue text. Is it possible to only sum if the color is either blue or bold.

    If so, please advise.

    Thanks so much.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sum if Color Blue (2002)

    See Chip Pearson's Functions For Cell Colors, in particular the section labeled "Summing The Values Of Cells With A Specific Color".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •