Formula for vlookup and then sum

[Alberta Rose]

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

 

[Mike H]

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

 

[Patrick Molloy]

2003
use array formula
{ =SUM((A1:A1000="A")*(F1:F1000)) }

note that you need to stipulate the rows ... blank rows are fine, so just
make the area quite large