#1
|
|||
|
|||
vlookup help
I am currently making a household check book. i have a Number Date Column1 Description of Transaction Debit (-) Credit (+) Balance
in column 1 i have set up keywords that i want to designate purchases paychecks food and general. how do i write the v look up formula to transfer the total of the information with balance onto a new sheet? |
#2
|
|||
|
|||
Can you upload a sample so I can see your layout and then i can let you know how to create the lookup formula.
|
#3
|
|||
|
|||
here is screen shot and new file
hopefully it uploaded correctly
|
#4
|
||||
|
||||
Why not use a Pivot Table?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
i would like to have it add each line in D ie... general walmart 55.01 general shell 10.20 as an example, bill verizon 200.00 bill mortgage 500.00 to another line in new sheet.
|
#6
|
|||
|
|||
Having looked at your file I'd use a SUMIF or pivottable.
I've attached a sample of the SUMIF and how you would have it work. |
#7
|
|||
|
|||
for some reason i just cant get it to work this is the formula im trying to use SUMIF($D$5:$D$16,TOTALS!$A$2:$B$6,0)
TOTALS IS NEW SHEET.IM TRYING TO HAVE IT CALCULATE ALL PRICES IN GENERAL IN ONE CELL ALL PRICES IN DEPOSIT IN ANOTHER CELL. I APPERICATE ALL THE HELP. |
#8
|
|||
|
|||
I think you are not getting the result because your SUMIF does not contain the correct arguments.
A SUMIF asks for the following arguments >Range, >Criteria, SumRange >Range: This is the range that the SUMIF will search for the next argument of >Criteria. So when the Criteria is met it will sum the next argument >SumRange. In order to accomplish the desired result this would be the formula to put into cell B2 on your totals page. Code:
=SUMIF('Check Register'!D:D,'TOTALS'!A2,'CHECK REGISTER'!G:G) Let me know if this fixes the issue or if you have any other questions. Thanks |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Vlookup Help | jimboslice | Excel | 3 | 09-05-2013 09:42 AM |
IF and VLOOKUP | SBMC | Excel | 1 | 11-07-2012 10:24 AM |
something like VLOOKUP | hanvyj | Excel | 4 | 03-13-2012 09:03 AM |
Vlookup | Karen615 | Excel | 4 | 09-12-2011 02:30 PM |
Using IF & VLOOKUP together | junction | Excel | 7 | 11-18-2010 05:15 AM |