Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-22-2014, 06:57 PM
framedbyhanging framedbyhanging is offline vlookup help Windows 8 vlookup help Office 2000
Novice
vlookup help
 
Join Date: Dec 2014
Posts: 4
framedbyhanging is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 12-25-2014, 05:31 AM
thetraininglady thetraininglady is offline vlookup help Windows 7 64bit vlookup help Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default

Can you upload a sample so I can see your layout and then i can let you know how to create the lookup formula.
Reply With Quote
  #3  
Old 12-26-2014, 06:33 AM
framedbyhanging framedbyhanging is offline vlookup help Windows 8 vlookup help Office 2000
Novice
vlookup help
 
Join Date: Dec 2014
Posts: 4
framedbyhanging is on a distinguished road
Default here is screen shot and new file

hopefully it uploaded correctly
Attached Images
File Type: png Screenshot (7).png (240.7 KB, 24 views)
File Type: png Screenshot (8).png (209.5 KB, 23 views)
Reply With Quote
  #4  
Old 12-26-2014, 09:11 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline vlookup help Windows 7 64bit vlookup help Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #5  
Old 12-26-2014, 09:48 AM
framedbyhanging framedbyhanging is offline vlookup help Windows 8 vlookup help Office 2000
Novice
vlookup help
 
Join Date: Dec 2014
Posts: 4
framedbyhanging is on a distinguished road
Default

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.
Reply With Quote
  #6  
Old 12-26-2014, 08:02 PM
thetraininglady thetraininglady is offline vlookup help Windows 7 64bit vlookup help Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default

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.
Attached Files
File Type: xlsx SUMIF.xlsx (12.1 KB, 9 views)
Reply With Quote
  #7  
Old 12-31-2014, 11:51 AM
framedbyhanging framedbyhanging is offline vlookup help Windows 8 vlookup help Office 2000
Novice
vlookup help
 
Join Date: Dec 2014
Posts: 4
framedbyhanging is on a distinguished road
Default

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.
Reply With Quote
  #8  
Old 12-31-2014, 09:57 PM
excelledsoftware excelledsoftware is offline vlookup help Windows 7 64bit vlookup help Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

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)
Once this formula is written you can copy and paste it to the other rows. the $ signs are not needed since you are only adapting the formula to rows and not columns.

Let me know if this fixes the issue or if you have any other questions.

Thanks
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup Help jimboslice Excel 3 09-05-2013 09:42 AM
vlookup help 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft