+ Reply to Thread
Results 1 to 2 of 2

SUM all cells with no background color in the same column

  1. #1
    Registered User
    Join Date
    01-11-2013
    Location
    Norway
    MS-Off Ver
    Excel 2003
    Posts
    1

    SUM all cells with no background color in the same column

    I hope anyone are able to help me out on this one. I need to find the total (Sum) of all cells with no background color in the same column.

    Is it possible? And how can it be done? See enclosed file for example.

    All help would be highly appreciated!

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: SUM all cells with no background color in the same column

    Here, try this UDF:

    First value of the function (i.e. E3) define color criteria: it will sum only values with same color.
    If you want blank - just use some criteria with blank color.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1