Hello,
I've run into a small problem while making a database to keep track of some stuff .
Here's what I'm trying to accomplish:
I've got a column with values like these:
2x €15,00 1x €20,00 1x €20,00; 2x €15,00 3x €15,00
I'd like to make a cell at the bottomthat counts how many times there's 15 and how many times there's 20 total.
As in, the above example would mean 7x €15,00 and 2x €20,00.
(If the output would be just "7;2" or 2 cells with just "7", "2", that would also be fine).
If I need to split it into two columns instead of 1, that's fine, although 1 column would be preferred
I hope someone can help me with this (if it's at all possible).
Kind Regards,
Chris
Bookmarks