+ Reply to Thread
Results 1 to 2 of 2

display sum of bold font amounts in a column in the lowest cell in the column

  1. #1
    Forum Contributor
    Join Date
    02-27-2020
    Location
    Rotterdam, The Netherlands
    MS-Off Ver
    2013
    Posts
    425

    display sum of bold font amounts in a column in the lowest cell in the column

    Hi,

    I have a sheet with amounts and subtotals. The subtotals are in bold font. I would like to create a macro that adds all amounts that have a bold font (the subtotals) in a certain column and put it in a certain cell below in the column. I get stuck with my own macro. Is it possible to write a macro like this ?

    Any input is much appreciated!


    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: display sum of bold font amounts in a column in the lowest cell in the column

    How about
    Please Login or Register  to view this content.

+ 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. [SOLVED] Formula to add column amounts unless cell is blank then add number in a different column
    By utahwilkinsons in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-31-2019, 10:48 AM
  2. Replies: 1
    Last Post: 05-10-2017, 05:14 PM
  3. [SOLVED] Formula Generation: Search column range, display cell from different column.
    By Old4xford in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-31-2014, 11:30 AM
  4. Replies: 8
    Last Post: 04-19-2013, 12:06 PM
  5. Replies: 3
    Last Post: 11-08-2012, 09:29 PM
  6. [SOLVED] Match dates in column B with column A across worksheets and sum any amounts in column G
    By daddywine in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-04-2012, 01:07 AM
  7. How can I sum only amounts that are in BOLD format within a column
    By Wanda in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-11-2005, 04:06 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