+ Reply to Thread
Results 1 to 2 of 2

autosum function within a formula?

  1. #1
    Registered User
    Join Date
    11-22-2013
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    1

    autosum function within a formula?

    Hi,

    For a friend I'm looking for a solution for the following:

    Sheet 1 (prodictlist) has a product list with product code, product name and price.
    Sheet 2 is a sales sheet to be used by volunteers entering what they sell for this non-profit organisation.

    In sheet 2, we'd like the following:
    Column A: The volunteer enters the product code of the item sold
    Column B: With a VLOOKUP, the product name is automatically filled out here: No problems.
    Column C: Again with a vlookup we want the price to appear here, BUT if the cell in column A is blank, we want the total of the above sales to appear there. On the next line we keep it blank and after that we want the volunteer to start entering data again.

    Example:

    A B C
    QD53 tea 2 euro
    QZ33 coffee 2 euro
    4 euro

    RU87 book 14 euro
    AK89 music 11 euro
    QD53 tea 2 euro
    27 euro

    etc...........

    The question: When pushing the autosum button, it usually adds the range above it, UNTILL there is a blank. But we don't want to push the autosum button, we want this option to be embedded in the formula. Is there such a formula that SUMS based on RANGE criteria such as "sum untill blank cell". Every cell in this colum should have the SAME formula so the volunteers only need to enter the product codes.
    Formula: =IF(ISBLANK(A8);AUTOSUM;(VLOOKUP(A8;Productlist!A:E;5;0)))

    Hope someone can help...

    Henri

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: autosum function within a formula?

    Hi and welcome to the forum

    I would suggest that you provide a small sample workbook, showing the type of data you are working with, and examples of your expected outcome
    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Autosum function in a Macro
    By Cambop in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-25-2012, 08:45 AM
  2. Autosum function Incorrect result
    By tartanswan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-01-2008, 08:38 AM
  3. Nested if-function - autosum
    By vvorland in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2008, 09:06 AM
  4. Autosum function
    By Frankie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-24-2006, 10:55 AM
  5. [SOLVED] Autosum function disappeared/knocked out
    By Simon Ryan in forum Excel General
    Replies: 2
    Last Post: 12-16-2005, 11:50 AM

Tags for this Thread

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