Formula help request for changing text in a cell into a currency value and totalling the a

Hi,

Got a problem and need help please.

Did excel many years a go and have now forgot most of it.

The scenario is:

Got text in a row/column (cell) and for each new row (cell) of text that is created it must show a currency value based on text input. So say that in a row/column (cell) it is days: Monday = £100, Tuesday = £100, Wednesday = empty (blank) and so on for the week or however may rows are completed with text in them = £100. Then I want to total the amount of rows with text in them, so if 49 rows have text in at £100 this would total £4,900 and so on for each column.

But I also need it to recognise when a new row (cell) has text added it will add the amount of stated or required i.e. £100 but could be £200 depending on the required setting in formula.

Any advice?

Thanks