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
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
Using your posted workbook....
D12: Tile
D13: Decor
This regular formula begins the totals for Tile and Decor:
Copy that formula across and down through J13![]()
Please Login or Register to view this content.
For your data, these are the results:
Is that something you can work with?![]()
Please Login or Register to view this content.
yeah that is it , why am I getting zero though my end ?
Okay I re did the formula without copy paste
Its not summing the decors
But its summing the tiles correctly with
=SUMIF($D$2:$D$11,$D2,E$2:E$11)
Okay I am using this be able to get the decor sum
=SUMIF($D$2:$D$11,$D5,E$2:E$11)
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 ?
Ron I will close the thread when you confirm
drag down meanwhile your formula sorts me with
the calculations and thank you
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.
Does that help?![]()
Please Login or Register to view this content.
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
Here you go...file attached
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)
Bookmarks