Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-22-2014, 06:57 PM
framedbyhanging framedbyhanging is offline Windows 8 Office 2000
Novice
 
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 Windows 7 64bit 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 Windows 8 Office 2000
Novice
 
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, 18 views)
File Type: png Screenshot (8).png (209.5 KB, 17 views)
Reply With Quote
  #4  
Old 12-26-2014, 09:11 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,224
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Why not use a Pivot Table?
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #5  
Old 12-26-2014, 09:48 AM
framedbyhanging framedbyhanging is offline Windows 8 Office 2000
Novice
 
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 Windows 7 64bit 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, 3 views)
Reply With Quote
  #7  
Old 12-31-2014, 11:51 AM
framedbyhanging framedbyhanging is offline Windows 8 Office 2000
Novice
 
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 Windows 7 64bit Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 453
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
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


All times are GMT -7. The time now is 11:40 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft