I know this is going to be something exceptionally simple and it's because I'm doing it via IF's (which technically return either a 0 or 1 for true of false) so I'll probably kick myself when you come back with a totally obvious answer.

I have this formula: =IF(J5="","",IF(C5="","",K5)) which returns either a value of 10p or £1.00 based on the results of the IF's, this formula is copied down for about 70 rows (with the row ref's increasing in each instance of the formula).

For a bit more reference;
Cell J5 is just a yes or no drop down
It checks C5 to ensure it's not blank
and K5 is =IF(C5="","",IF(J5="No","10p","£1.00"))
(I'm beginning to think I've made this too complicated for what it needs to be!)

What I want to do is have one cell that totals all the amounts into one easy to read figure for a sales spreadsheet to help work out our profit margin on a batch of data.