Results 1 to 8 of 8

Summing by colour and category

Threaded View

  1. #1
    Registered User
    Join Date
    06-03-2015
    Location
    UK
    MS-Off Ver
    MS Office 15
    Posts
    11

    Summing by colour and category

    I would like to build a formula that will evaluate the sum of a range of cells based on not only the category they relate to, but also on the colour that specific shells are shaded. I've attached an example spreadsheet of what I'm trying to do to help visualise this better.

    Any help would be greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Summing each category per month
    By stevewilde in forum Excel General
    Replies: 5
    Last Post: 04-25-2014, 10:01 PM
  2. [SOLVED] Summing Data by Week Ending and Category
    By cpalmer72 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-12-2013, 11:13 PM
  3. Summing Data by Week Ending and Category
    By cpalmer72 in forum Excel General
    Replies: 1
    Last Post: 10-03-2013, 02:30 PM
  4. Bar Chart - how to colour specific category axis values.
    By Richard Buttrey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2010, 08:58 AM
  5. Replies: 0
    Last Post: 08-28-2005, 11:07 AM
  6. [SOLVED] Summing Data based on Its Category
    By sip8316 in forum Excel General
    Replies: 2
    Last Post: 05-24-2005, 03:06 PM
  7. summing an array by product category
    By BLW in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2005, 07:06 PM
  8. Colour code category axis labels
    By MattShoreson in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-02-2005, 11:32 AM

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