+ Reply to Thread
Results 1 to 2 of 2

SUM all cells with no background color in the same column

Hybrid View

  1. 01-11-2013, 07:47 AM #1
    tveheim
    tveheim is offline
    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
    Reply With QuoteRegister To Reply
  2. 01-11-2013, 08:30 AM #2
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,061

    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
    Never use Merged Cells in Excel
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1