+ Reply to Thread
Results 1 to 6 of 6

Combining multiple functions>lookup/sum functions

  1. #1
    Registered User
    Join Date
    05-22-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Combining multiple functions>lookup/sum functions

    Someone help me please.
    I have attached a table here and i want to come up with a formula that can help me to get a summation of say all floor tiles attributed to Maureen in ctns....
    Many Thanks

    Mush
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Combining multiple functions>lookup/sum functions

    Put this code into spreadsheet

    Please Login or Register  to view this content.
    likewise for betty and Ann
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-22-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Combining multiple functions>lookup/sum functions

    Thank you.
    just to explain a little further, there is a column for floor times and wall tiles. Also, there is there is a column with pcs and ctns. I would appreciate a formula that will help me sum up the total for maureen's floor tiles in ctns and in pcs as well.
    Thanks again

  4. #4
    Registered User
    Join Date
    01-03-2011
    Location
    Bucharest
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Combining multiple functions>lookup/sum functions

    Hello!
    Try this one: =(COUNTIFS(C:C;"Floor Tiles";I:I;"Maureen")

  5. #5
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Combining multiple functions>lookup/sum functions

    made a little table which you can add to easily
    see attached
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    01-03-2011
    Location
    Bucharest
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Combining multiple functions>lookup/sum functions

    Please find attached and see if is what you are looking for.

    Best of luck!
    Attached Files Attached Files

+ Reply to Thread

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