MYUSERNAMEIS
New Member
- Joined
- Jan 4, 2017
- Messages
- 4
Hello,
I want to get a sum of prices for column AA, but only counting 1 occurrence of each individually named Item in column U - for example if the formula worked it would return £16 in AA42 - it would ignore duplicate Supplier Item Names (Row U)
There are some filtered out rows which I do not want to be counted.
Cells in columns X and ZZ contain formula that refer to other cells elsewhere in the spreadsheet.
Any help would be greatly appreciated.
I have previously had great help from this forum, the help I got last year was perfect - but my spreadsheet has evolved a lot since then, and the formula is not suited to what I want it to do now, I have tried tweaking it, but as an excel novice I don't know what I am doing and am getting nonsensical results.
Here is the previous thread;
https://www.mrexcel.com/forum/excel-...ered-list.html
<tbody>
</tbody>
I want to get a sum of prices for column AA, but only counting 1 occurrence of each individually named Item in column U - for example if the formula worked it would return £16 in AA42 - it would ignore duplicate Supplier Item Names (Row U)
There are some filtered out rows which I do not want to be counted.
Cells in columns X and ZZ contain formula that refer to other cells elsewhere in the spreadsheet.
Any help would be greatly appreciated.
I have previously had great help from this forum, the help I got last year was perfect - but my spreadsheet has evolved a lot since then, and the formula is not suited to what I want it to do now, I have tried tweaking it, but as an excel novice I don't know what I am doing and am getting nonsensical results.
Here is the previous thread;
https://www.mrexcel.com/forum/excel-...ered-list.html
| Column | T | U | V | W | X | Y | Z | AA |
| Row No. | SUPPLIER | SUPPLIER Item Name | SUPPLIER Item Code | SUPPLIER price / pack | NO. to ORDER | P+P | Cost / Supplier Unit Ex VAT | TOTAL ex VAT |
| 24 | amazon | 4 Digit Combination Padlock | Desired tools | £1.00 | 2.00 | £0.00 | £1.00 | £2.00 |
| 25 | Ebay | 1 minute sand egg timer | n/a | £2.00 | 1.00 | £0.00 | £2.00 | £2.00 |
| 26 | Ebay | 1 minute sand egg timer | n/a | £2.00 | 1.00 | £0.00 | £2.00 | £2.00 |
| 38 | Amazon | 100 disposable 7" white Plastic Plates | Best Values | £3.00 | 1.00 | £3.00 | £3.00 | £3.00 |
| 39 | Amazon | 100 disposable 7" white Plastic Plates | Best Values | £3.00 | 1.00 | £3.00 | £3.00 | £3.00 |
| 40 | aladdin | 100 x skewers in bamboo 250mm | n/a | £4.00 | 1.00 | £0.00 | £4.00 | £4.00 |
| 41 | Amazon | 1000 Paper 50mm Diameter Round Mixed Colour Code Stickers | LabelWonderland | £5.00 | 1.00 | £0.00 | £5.00 | £5.00 |
| £16.00 |
<tbody>
</tbody>
