Results 1 to 4 of 4

Thread: Help Please -Sum off multiple adjacent cells
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2018
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Help Please -Sum off multiple adjacent cells

    Hi,

    I require some help please. I am looking for an equation to that will sum based on multiple adjacent cells have specific terms.

    I need to total the revenue in row D for all lines that have a specific working in Row A B and C

    See example below:

    I need a formula to automatically calculate the total revenue in Column D doe:

    Melbourne + Car + Retail
    Melbourne + Bus + Retail

    etc etc

    A B C D
    1 location Type Customer Revenue
    2 MELBOURNE CAR RETAIL $100
    3 MELBOURNE BUS RETAIL $100
    4 SYDNEY BUS RETAIL $200
    5 MELBOURNE CAR RETAIL $200
    6 SYDNEY BUS CORPORATE $150
    7 MELBOURNE BUS CORPORATE $200
    8 SYDNEY BUS CORPORATE $250

    If someone could help it would be a really big help to me.

    Thank you
    Hailey

  2. #2
    Board Regular
    Join Date
    Sep 2005
    Posts
    5,103
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help Please -Sum off multiple adjacent cells

    Sumifs is a formula solution. Or you can set a pivot table.

  3. #3
    New Member
    Join Date
    May 2018
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help Please -Sum off multiple adjacent cells

    Quote Originally Posted by sheetspread View Post
    Sumifs is a formula solution. Or you can set a pivot table.
    Are you able to assist me with a formula?, I tried and somehow I'm mucking it up. Thankyou

  4. #4
    New Member
    Join Date
    May 2018
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help Please -Sum off multiple adjacent cells

    I figured it out - thankyou!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •