Hi,
I have a spreadsheet which is to be used to monitor spend according to
specific cost codes. I am having problems though in writing formulas that
actually work..

Can anyone help in writing a formula to work out the total spend (£) (which
could be in any of the cells h44:h420), for spend which is on a certain cost
code e.g. '6210 - Oil' which can be in any of the cells e44:e420. The new
total (£) needs to go into cell d2.

If I can see how to do one cost code, I can then alter the formula to work
out the others.

note column d uses a drop down input

I'm sure its simple, but I'm struggling.

Cheers