Hi,

You can only use full columns in E2007 for E2003 and earlier define a
shorter range

=SUMPRODUCT((A:A="Your cost code")*(F:F))

Mike

"Alberta Rose" wrote:

Hello. I need a formula to do a vlookup for whenever a certain cost
code/cost type appears in column A, then go to column F and sum the dollar
amounts. Help please :)