Hi all,
Haven't found anything like this posted before, so I had to post it.
Im looking for a way to sum the Britisch pounds sterling from a column which consists out of Pounds and Euro's in Excel (not VBA).
Example:
£ 3050,00
€ 630,54
£ 2300,00
£ 4500,50
€ 219,00
€ 7853,86
€ 234,63
€ 421,11...