+ Reply to Thread
Results 1 to 8 of 8

Macros to add up Bold Numbers Only

  1. #1
    Forum Contributor
    Join Date
    02-02-2013
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2010
    Posts
    167

    Macros to add up Bold Numbers Only

    I'm using Office 365. I would like to know how to add up just the "Bold Numbers Only" based on which cell the "Total Cost" lands. "Total Cost" will always be in column "D", but it will not always land in the same row. All of my Totals land in column "G" and come in correctly and total up correctly each time, but the "Total Cost" does not, so I'm just looking for a macros just to handle the "Total Cost". I will create a control button for this action. See attached for a better under standing. I appreciate any help I can get for this.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,952

    Re: Macros to add up Bold Numbers Only

    Old accounting trick - use the formula:

    =SUM(G1:G83)/2

    You are rounding incorrectly - don't round, and it will all work.

    Also, there is no need for the SUM, since you are referencing a single cell in your formula

    =ROUND(SUM('C:\Users\rchristensen\Desktop\[Proposal_Test.xlsm]Sheet1'!K88),1)

    =ROUND('C:\Users\rchristensen\Desktop\[Proposal_Test.xlsm]Sheet1'!K88,1)
    Last edited by Bernie Deitrick; 05-12-2023 at 01:50 PM.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Forum Contributor
    Join Date
    02-02-2013
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2010
    Posts
    167

    Re: Macros to add up Bold Numbers Only

    Thanks for the quick answer on this. Yes I could use =SUM(G1:G83)/2, but it does not always land between G1:G3, this is why I was looking for a macros that would pickup the bold numbers in column "G" based on where "Total Cost lands in column "D". I also changed the order for my totals and got the same results.

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,952

    Re: Macros to add up Bold Numbers Only

    You can also use

    =SUMIF(D:D,"SubTotal*",G:G)

  5. #5
    Forum Contributor
    Join Date
    02-02-2013
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2010
    Posts
    167

    Re: Macros to add up Bold Numbers Only

    I'm using Office 365. I would like to know how to add up just the "Bold Numbers Only" based on which cell the "Total Cost" lands. "Total Cost" will always be in column "D", but can land anywhere between D31:D209. All of my Totals land in column "G" and come in correctly and subtotal up correctly each time, but the "Total Cost" does not, so I'm just looking for a macros just to handle the "Total Cost". I will create a control button for this action. See attached for a better under standing. I appreciate any help I can get for this.
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,952

    Re: Macros to add up Bold Numbers Only

    Did you try the formula - it works great for me.

  7. #7
    Forum Contributor
    Join Date
    02-02-2013
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2010
    Posts
    167

    Re: Macros to add up Bold Numbers Only

    Can you please send it to me as an example in an excel sheet. Thank you

  8. #8
    Forum Contributor
    Join Date
    02-02-2013
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2010
    Posts
    167

    Re: Macros to add up Bold Numbers Only

    How can I add this =SUMIF(D32:D209,"SubTotal*",G32:G209) to a macros button?

+ 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. Count of Bold numbers
    By goodboy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-06-2017, 09:45 AM
  2. Count of Bold numbers
    By goodboy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-06-2017, 08:56 AM
  3. [SOLVED] Color & Bold selected numbers
    By Ucpaul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2013, 01:33 PM
  4. Change only numbers bold
    By weidscreen in forum Excel General
    Replies: 2
    Last Post: 06-09-2011, 12:18 PM
  5. Sum only numbers in bold in a range
    By Irdanwen in forum Excel General
    Replies: 1
    Last Post: 03-06-2008, 05:33 PM
  6. SUMIF - adding numbers that are bold
    By mattsgr1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-11-2007, 07:11 AM
  7. Re: Summarize only numbers printed in Bold?
    By B.Esbaum in forum Excel General
    Replies: 1
    Last Post: 07-19-2006, 07:45 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