+ Reply to Thread
Results 1 to 4 of 4

Sum some columns based on row color

  1. 04-29-2017, 02:10 PM #1
    DanS52
    DanS52 is offline
    Registered User
    Join Date
    04-02-2017
    Location
    Bakersfield, california
    MS-Off Ver
    2010
    Posts
    26

    Sum some columns based on row color

    I just have an issue or two, one caused by me trying to change some code which I know little about
    but am learning.
    1. I need another row on the monthly fert sheet that sums just the columns in the colored rows. (Call it "Season Totals") That way I get a total of each nutrient for the whole year or season.
    2. Also, two rows are being skipped in between the monthly totals , I would like only one row skipped. It takes up too much space on the final printout.
    On the monthly fert sheet I put question marks where I need the sum of just the totals from above.Nut Tree Nutrient Plan.xlsm
    Reply With QuoteRegister To Reply
  2. 04-29-2017, 02:57 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Sum some columns based on row color

    If the totals rows are changing month to month, use ( in E27, etc.):
    Please Login or Register  to view this content.
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 04-29-2017, 03:56 PM #3
    Tsjallie
    Tsjallie is offline
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Sum some columns based on row color

    Attached an adjusted workbook. Hope it does what you need.

    Add Seasons Totals row:
    In the macro attached to ClearContents button in Monthly Fert sheet changed the range to clear (A4:R100->A7:R100)
    Moved the Season Totals row in Monthly Fert sheet to row 5.

    One blank row instaead of two
    In the macro attached to SentToMonthly button in Fert Plan sheet changed nextrow:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Cheers!
    Tsjallie



    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...
    Reply With QuoteRegister To Reply
  4. 04-30-2017, 09:59 AM #4
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: Sum some columns based on row color

    Hi Dan52

    Went a bit of a different root that allows for Grand Totals at bottom..
    Attached Files Attached Files
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    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)

Similar Threads

  1. Hide columns on multiple sheets based on tab color
    By kluftman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2015, 02:17 PM
  2. Match Data in 2 columns, color line based on out come
    By charmallan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2015, 07:45 PM
  3. VBA to match highlighted columns and color based off value
    By cmccabe in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-12-2014, 08:10 PM
  4. [SOLVED] Categorizing data based on color, then split into columns?
    By heidilaw4 in forum Excel General
    Replies: 5
    Last Post: 05-15-2013, 10:52 PM
  5. Delete Columns Based On Fill Color
    By jlkirk in forum Excel General
    Replies: 7
    Last Post: 01-28-2013, 02:00 PM
  6. VBA Stacked columns based on cells without color
    By MarkStorm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-17-2012, 08:07 AM
  7. [SOLVED] How do I add conditional color to my rows based on two columns?
    By LarryDH in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-02-2012, 01:14 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1