Formula for vlookup and then sum

  • Thread starter Thread starter Alberta Rose
  • Start date Start date
A

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