+ Reply to Thread
Results 1 to 12 of 12

Summing Tiles and Summing Tile Decors

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    2,950

    Summing Tiles and Summing Tile Decors

    I want to sum tiles only and decors only
    differently , I have specified which ones
    are tiles and which ones are decors in the
    attachment

    I know one method that i don't want to use,
    that of holding CTRL and selecting range to sum
    Attached Files Attached Files

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Summing Tiles and Summing Tile Decors

    Using your posted workbook....
    D12: Tile
    D13: Decor

    This regular formula begins the totals for Tile and Decor:
    Please Login or Register  to view this content.
    Copy that formula across and down through J13

    For your data, these are the results:
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    2,950

    Re: Summing Tiles and Summing Tile Decors

    yeah that is it , why am I getting zero though my end ?

  4. #4
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    2,950

    Re: Summing Tiles and Summing Tile Decors

    Okay I re did the formula without copy paste
    Its not summing the decors

  5. #5
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    2,950

    Re: Summing Tiles and Summing Tile Decors

    But its summing the tiles correctly with

    =SUMIF($D$2:$D$11,$D2,E$2:E$11)

  6. #6
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    2,950

    Re: Summing Tiles and Summing Tile Decors

    Okay I am using this be able to get the decor sum

    =SUMIF($D$2:$D$11,$D5,E$2:E$11)

  7. #7
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    2,950

    Re: Summing Tiles and Summing Tile Decors

    Ron Coderre I am sorted out , I am just keeping the
    thread open for someone to clarify drag right and drag
    down to work as one formula

    I am not able to drag down to make it work for decor
    totals , I am curious to know if that should work ?

  8. #8
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    2,950

    Re: Summing Tiles and Summing Tile Decors

    Ron I will close the thread when you confirm
    drag down meanwhile your formula sorts me with
    the calculations and thank you

  9. #9
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Summing Tiles and Summing Tile Decors

    That would happen if the value in D13 does not exactly match the CAT values. Typically, leading or trailing spaces are the culprit. Try copying on of the DECOR cell values into D13.
    Then, this formula, dragged down then dragged across, should work.

    Please Login or Register  to view this content.
    Does that help?

  10. #10
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    2,950

    Re: Summing Tiles and Summing Tile Decors

    It will help surely , please attach the file ,
    since I don't understand you

    Thanks you again for the trouble , i will close
    the thread since I expect you will have attached
    the file once I wake in the morning and check

  11. #11
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Summing Tiles and Summing Tile Decors

    Here you go...file attached
    Attached Files Attached Files

  12. #12
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    2,950

    Re: Summing Tiles and Summing Tile Decors

    Thanks Ron , here is the way I archive
    my answers , with attaching you photo
    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)

Similar Threads

  1. [SOLVED] Help with Summing Duplicates, deleting rows after summing and filling col. for unsummed
    By solidrock1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2014, 09:11 AM
  2. summing up
    By torpido in forum Excel General
    Replies: 6
    Last Post: 09-07-2008, 07:33 AM
  3. Summing
    By eehod in forum Excel General
    Replies: 5
    Last Post: 07-11-2007, 01:44 PM
  4. Summing Columns-revolves around summing particular items
    By savv32 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-06-2005, 09:05 PM
  5. [SOLVED] Can I tile worksheets within a workbook, like one tiles workbooks.
    By Tovarish_Dad in forum Excel General
    Replies: 2
    Last Post: 07-06-2005, 05:05 PM

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