Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I combine a VLOOKUP formula and a NETWORKDAYS formula? | Excel Worksheet Functions | |||
Link an IF formula with a cell containing a Vlookup formula | Excel Programming | |||
Alternative formula to the vlookup formula? | Excel Worksheet Functions | |||
convert vlookup formula to link formula | Excel Worksheet Functions | |||
Excel 2002 VLOOKUP formula or other formula | Excel Discussion (Misc queries) |