Formula for vlookup and then sum
 

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 :)

Formula for vlookup and then sum
 

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 :)

Formula for vlookup and then sum
 

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

"Alberta Rose" wrote in message
...
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 :)