# Summing Tiles and Summing Tile Decors

1. ## 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

2. ## Re: Summing Tiles and Summing Tile Decors

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?

3. ## Re: Summing Tiles and Summing Tile Decors

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

4. ## Re: Summing Tiles and Summing Tile Decors

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

5. ## 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. ## 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. ## 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. ## 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. ## 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. ## 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. ## Re: Summing Tiles and Summing Tile Decors

Here you go...file attached

12. ## Re: Summing Tiles and Summing Tile Decors

Thanks Ron , here is the way I archive
my answers , with attaching you photo

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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