+ Reply to Thread
Results 1 to 3 of 3

Only Count Cells with Specified Cell Color without using VBA

  1. #1
    Forum Contributor garrett.grillo's Avatar
    Join Date
    06-19-2011
    Location
    San Francisco, California
    MS-Off Ver
    Excel 2010
    Posts
    188

    Only Count Cells with Specified Cell Color without using VBA

    I have to put together and submit multiple cost reports to our management on a monthly basis.

    In my Cost Summary Report, I need a Non-VBA solution that will Match and Index (equation) its way through an SAP Raw Excel Report (export) of actual costs and retrieve only those cell value totals that will first (1st) align vertically with the matching WBS Element row and horizontally with the matching Actual Cost column titles, then secondly (2nd) for the equation to work I need it to only return each WBS Element and Actual Cost total value by its cell color (orange).

    See the attached/linked excel example for further help and information.

    PLEASE help if you know of any methods or equation that will enable me to only count these orange colored WBS total cells without the using VBA.

    If it is not possible, please help me add a VBA code to my attached excel example that will work.

    Thank You!

    SUMIF by Cell Data and Color Example.xlsx


    Garrett
    Last edited by garrett.grillo; 03-04-2014 at 06:17 PM.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Only Count Cells with Specified Cell Color without using VBA

    How to install your new code
    1. Copy the Excel VBA code
    2. Select the workbook in which you want to store the Excel VBA code
    3. Press Alt+F11 to open the Visual Basic Editor
    4. Choose Insert > Module
    5. Edit > Paste the macro into the module that appeared
    6. Close the VBEditor
    7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

    Please Login or Register  to view this content.
    In C4 Cell

    =SumifByColor(B4,$B$10:B$18,$C$10:$C$18)

    Drag it down...


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Only Count Cells with Specified Cell Color without using VBA

    A non-VBA optopn would be...
    =SUMIF($B$10:$B$19,B4,$C$10:$C$19)/2
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 05-02-2012, 09:08 AM
  2. Replies: 1
    Last Post: 06-16-2006, 08:55 PM
  3. HOW DO I COUNT CELLS OF A CERTAIN COLOR ONLY?
    By Martin C in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  4. [SOLVED] HOW DO I COUNT CELLS OF A CERTAIN COLOR ONLY?
    By Martin C in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  5. how to formate cells to count cells with a fill color?
    By Moore in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-15-2005, 02:05 PM

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