+ Reply to Thread
Results 1 to 2 of 2

AutoSum Either Or

Hybrid View

  1. 09-01-2008, 11:10 AM #1
    nironto
    nironto is offline
    Forum Contributor
    Join Date
    09-01-2008
    Location
    Australia
    Posts
    108

    AutoSum Either Or

    Hi guys,
    My current formula is AutoSum ( C30 - C50).
    This is not what i want.

    Part A = C30 to C40
    Part B = C41 to C50
    Either Part A or Part B should be used instead (and not the sum of Part A + Part B).
    If Part A is selected, Part B is void. vice versa.

    What i need is...
    Subtotal = Either (Sum of C30 to C40) or (Sum of C41 to C50)
    How do I go about it?
    Reply With QuoteRegister To Reply
  2. 09-01-2008, 11:24 AM #2
    ratcat
    ratcat is offline
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111
    G'day noronto

    and welcome to the forum.

    From what you have explained you need the IF formula.

    But value determines if part A or part B is selected for the subtotal

    Cheers
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it
    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. how to do autosum 5(4,5) without the numbers in ()
    By okl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-17-2008, 08:04 AM
  2. Setting Automatic Difference Across Columns Like AutoSum
    By Lavarinth in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-20-2007, 05:55 PM
  3. AutoSum Problem
    By luckyxcharms in forum Excel General
    Replies: 2
    Last Post: 09-21-2007, 12:01 PM
  4. User with AutoSum problems
    By craziefro in forum Excel General
    Replies: 9
    Last Post: 04-05-2007, 09:21 AM
  5. Autosum row
    By drdoom in forum Excel General
    Replies: 2
    Last Post: 03-28-2007, 09:08 AM

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