Results 1 to 7 of 7

[SOLVED]Sum cells based on color

Threaded View

blackshag [SOLVED]Sum cells based on... 11-19-2012, 04:10 PM
protonLeah Re: Sum cells based on color 11-19-2012, 04:27 PM
FDibbins Re: Sum cells based on color 11-19-2012, 04:30 PM
blackshag Re: Sum cells based on color 11-19-2012, 04:41 PM
FDibbins Re: Sum cells based on color 11-19-2012, 05:15 PM
blackshag Re: Sum cells based on color 11-19-2012, 05:34 PM
Kevin UK Re: Sum cells based on color 11-19-2012, 05:35 PM
  1. #1
    Registered User
    Join Date
    11-02-2012
    Location
    WA
    MS-Off Ver
    Excel 2010
    Posts
    21

    [SOLVED]Sum cells based on color

    Currently column AO tracks all payments due to venders.
    The cells turn brown if those payments are due within 10 days.

    See attached .jpg

    What would be the appropriate formula so that:

    AO74=sum all of the brownish colored cells
    It would ignore all other cells.

    excel question.jpg

    Anyone have any ideas?
    Last edited by blackshag; 11-19-2012 at 05:51 PM. Reason: Clarification

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