+ Reply to Thread
Results 1 to 3 of 3

Complex function/formula to aggregate revenue totals

  1. #1
    Registered User
    Join Date
    06-09-2016
    Location
    Sydney, Australia
    MS-Off Ver
    10?
    Posts
    2

    Complex function/formula to aggregate revenue totals

    Hello,

    I am in need of some help with a function or formula for a revenue tracking sheet I am creating for a new business.

    The business sells multiple products that are displayed in a pipeline.

    I need to be able to collate the totals of each product sold for quick reference. Therefore a need a formula for cells C5 - C8 to bring in the revenue totals for each product name.

    The products are identified in column G and the revenue per opportunity sold is displayed in column E.

    Please let me know if you can help me, and let me know if you have any questions at all.

    Cheers
    Stevie82
    Attached Images Attached Images

  2. #2
    Forum Contributor amit.wilson's Avatar
    Join Date
    07-09-2013
    Location
    Gotham
    MS-Off Ver
    Excel for Mac 2011
    Posts
    283

    Re: Complex function/formula to aggregate revenue totals

    S,

    have you tried SumIf()?

    If you want to add the forecast numbers (in column F) by product name, you could try in B5
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Cheers
    <-- If you're happy & you know it...click the star.:-)

  3. #3
    Registered User
    Join Date
    06-09-2016
    Location
    Sydney, Australia
    MS-Off Ver
    10?
    Posts
    2

    Re: Complex function/formula to aggregate revenue totals

    Thats the one batman! Thanks so much.

+ 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] which formula will be used for Greater Than and Less Than within AGGREGATE Function?
    By Imran Magsi in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-19-2016, 03:15 AM
  2. [SOLVED] AGGREGATE Function
    By chief_abound in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-03-2015, 12:48 AM
  3. Aggregate totals for columns by category vs budget
    By FuzzyFrog in forum Excel General
    Replies: 4
    Last Post: 04-23-2014, 10:31 AM
  4. Aggregate Function
    By nav505 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-04-2013, 03:20 AM
  5. Charting totals in revenue by month
    By pentatonic145 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-21-2008, 04:56 PM
  6. [SOLVED] adding totals... more complex than it sounds..
    By the_top_man@hotmail.com in forum Excel General
    Replies: 5
    Last Post: 08-10-2006, 11:10 AM
  7. Using a sperate sheet to save daily revenue totals
    By justchris in forum Excel General
    Replies: 1
    Last Post: 03-09-2005, 01:49 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1