I need a way to make a number of words equal to a numerical currency, for example:
Email = £2
Cheque = £66.5
Every time the word Email occurs in this column i need it to tally in a separate box, eg if it appears 10 times i need £20 to appear elsewhere on the the same sheet
Every time the word Cheque occurs in this column i need it to tally in a separate box, eg if it appears 10 times i need £665 to appear elsewhere on the same sheet.
I then need to tally the both together for a total cost.
Can someone assist me here?
Bookmarks