+ Reply to Thread
Results 1 to 3 of 3

Formula help- v lookup & cash flow

  1. #1
    Registered User
    Join Date
    05-14-2020
    Location
    derbyshire
    MS-Off Ver
    365
    Posts
    11

    Formula help- v lookup & cash flow

    Hi, I was hoping someone could help.. I am trying to build a cash flow with data exported straight from the bank into excel. I am exporting this and then using a pivot table to summarise the info on a daily basis. From here I am trying to set up a v lookup to pull the data from the pivot table to the main cash flow template. See below attached what am I doing wrong?

    Does any one have any suggestions on what to use to build a cash flow with daily income and expenses?

    Thanks Amy
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,481

    Re: Formula help- v lookup & cash flow

    Instead of PV using, try SUMIFS in B2:
    Please Login or Register  to view this content.
    Drag down and accross
    Quang PT

  3. #3
    Registered User
    Join Date
    05-14-2020
    Location
    derbyshire
    MS-Off Ver
    365
    Posts
    11

    Re: Formula help- v lookup & cash flow

    Thank you that works

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 07-23-2017, 11:21 PM
  2. Sumifs cash flow formula
    By Lizzieboomboom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-20-2017, 03:54 PM
  3. Apartment Rent Roll Cash Flow Formula
    By $J$L$G in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-10-2016, 11:31 PM
  4. NPV / PV Calculation / Formula with Cumulative / Compounding Cash Flow
    By donkeybusiness in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-08-2015, 10:36 AM
  5. [SOLVED] Formula to determine monthly cash flow based on customer contract length
    By Wedge120 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-31-2013, 08:42 PM
  6. Replies: 5
    Last Post: 02-21-2012, 05:42 AM
  7. How can I Lookup and sum payments for cash flow forecast?
    By Aaron in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-28-2005, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1