Results 1 to 18 of 18

Need Strikethrough To Subtract Value From Subtotal

Threaded View

  1. #1
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Question Need Strikethrough To Subtract Value From Subtotal

    I have a situation where Cell A1 displays the subtotal of Cells A2 through A10:

    Cell A1=100
    Cell A2=20
    Cell A3=30
    Cell A4=40
    Cell A10=10

    I need the subtotal cell to subtract any of the values that get formatted with the Strikethrough feature:

    Cell A1=60
    Cell A2=20
    Cell A3=30
    Cell A4=40 (this value receiving the strikethrough)
    Cell A10=10

    How can this be done?
    Last edited by swordswinger710; 03-06-2012 at 03:25 PM.
    There is so much good in the worst of us,
    And so much bad in the best of us,
    That it hardly behooves any of us
    To talk about the rest of us.

Thread Information

Users Browsing this Thread

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

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