Named cells - Can I sum all their values?

[skiddlin]

I have a spreadsheet where I 'name' cells.

e.g Cell named 'Flowers' has a value of £2.20, means I can do this '=sum(Flowers*15)' = £33.

Does anyone know if it is possible to have excel 2007 find the total value (the £33 bit) of named cells where they appear a number of times in the same workbook?

Thanks!!!

[Steve R]

I am not following you.

Can you post a example workbook without sensitive data?