richard1234567891011
Board Regular
- Joined
- Feb 21, 2018
- Messages
- 91
Hi guys, I need a formula with a sum for data.
Example, I halve these data:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #DFF8D6"]PE - PESCARA - CAFFE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]3030[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]TAX[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #DFF8D6"]PE - PESCARA - CAFFE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]3636[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]TAX[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #DFF8D6"]PE - PESCARA - CAFFE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]1212[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]TAX[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #CEFBF5"]PE - PESCARA - Sub34[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]52672,95[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Buy[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #CEFBF5"]PE - PESCARA - Sub35[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]53389,13[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Buy[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #CEFBF5"]PE - PESCARA - Sub36[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]42281,33[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Buy[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #CEFBF5"]PE - PESCARA - Sub37[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]51956,1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Buy[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #CEFBF5"]PE - PESCARA - Sub38[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,63[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #CEFBF5"]PE - PESCARA - Sub39[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,64[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #CEFBF5"]PE - PESCARA - Sub40[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,64[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #CEFBF5"]PE - PESCARA - Sub41[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,63[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="width: 139"]CH - CHIETI - Sub35[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,65[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="width: 139"]CH - CHIETI - Sub39[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,64[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="width: 139"]CH - CHIETI - Sub40[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,64[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="width: 139"]CH - CHIETI - Sub41[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,64[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="width: 139"]CH - CHIETI - Sub42[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,62[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="width: 139"]CH - CHIETI - Sub43[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,62[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="width: 139"]CH - CHIETI - Sub44[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,64[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
II need a formula to sum all the same tipe of cost x same/similar cost allocator.
Example
Tax: sum of 3030, 3636, 1212 as result (because all are taxes and all are under [TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #DFF8D6"]PE - PESCARA - CAFFE[/TD]
[/TR]
</tbody>[/TABLE]
Buy: sum of 52672,95 + 53389,13 + 42281,33 + 51956,1 because are all under buy and all are in the same cost allocator, even if it is slightly different.
Thank you Guys,
Example, I halve these data:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #DFF8D6"]PE - PESCARA - CAFFE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]3030[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]TAX[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #DFF8D6"]PE - PESCARA - CAFFE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]3636[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]TAX[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #DFF8D6"]PE - PESCARA - CAFFE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]1212[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]TAX[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #CEFBF5"]PE - PESCARA - Sub34[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]52672,95[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Buy[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #CEFBF5"]PE - PESCARA - Sub35[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]53389,13[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Buy[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #CEFBF5"]PE - PESCARA - Sub36[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]42281,33[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Buy[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #CEFBF5"]PE - PESCARA - Sub37[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]51956,1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Buy[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #CEFBF5"]PE - PESCARA - Sub38[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,63[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #CEFBF5"]PE - PESCARA - Sub39[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,64[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #CEFBF5"]PE - PESCARA - Sub40[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,64[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #CEFBF5"]PE - PESCARA - Sub41[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,63[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="width: 139"]CH - CHIETI - Sub35[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,65[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="width: 139"]CH - CHIETI - Sub39[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,64[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="width: 139"]CH - CHIETI - Sub40[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,64[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="width: 139"]CH - CHIETI - Sub41[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,64[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="width: 139"]CH - CHIETI - Sub42[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,62[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="width: 139"]CH - CHIETI - Sub43[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,62[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 139"]
<tbody>[TR]
[TD="width: 139"]CH - CHIETI - Sub44[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl73, width: 87, align: right"]989,64[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl73, width: 127"]Legal Expense[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
II need a formula to sum all the same tipe of cost x same/similar cost allocator.
Example
Tax: sum of 3030, 3636, 1212 as result (because all are taxes and all are under [TABLE="width: 139"]
<tbody>[TR]
[TD="class: xl73, width: 139, bgcolor: #DFF8D6"]PE - PESCARA - CAFFE[/TD]
[/TR]
</tbody>[/TABLE]
Buy: sum of 52672,95 + 53389,13 + 42281,33 + 51956,1 because are all under buy and all are in the same cost allocator, even if it is slightly different.
Thank you Guys,