+ Reply to Thread
Results 1 to 2 of 2

Forensic Accounting Unknown Formula Error Between Worksheets

  1. #1
    Registered User
    Join Date
    01-14-2013
    Location
    Vancouver, WA
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    24

    Forensic Accounting Unknown Formula Error Between Worksheets

    I have a spreadsheets which I am unable to determine why the deposits on the first worksheet called "Accounting" are not showing up. They are supposed to carry over from the 2nd worksheet called "Transactions". I'm certain I've got an error in the formula, but I cannot figure it out. I would be very grateful if someone would please help me with this. Thank you so much. -Max
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-11-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2010
    Posts
    129

    Re: Forensic Accounting Unknown Formula Error Between Worksheets

    Your expenses are ligning up as they are taken from column c in "Transactions", however your Deposits are taken from column "D" in Transactions and you have column c in your formula as part of Criteria 1 of your SUMIFS formula.

    Hope that helps

+ 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. [SOLVED] FindFormat Accounting Error
    By yusunghee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2013, 12:02 PM
  2. Forensic Accounting Formula Help Desperately Needed
    By spurredhal in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-20-2013, 04:27 PM
  3. Unknown error, possible formula too long.
    By Saidrex in forum Excel General
    Replies: 15
    Last Post: 12-21-2011, 10:41 AM
  4. [SOLVED] Help with this error Unknown reason for error with Range().Select
    By Brad Sumner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2005, 12:05 PM
  5. Forensic Spreadsheet Review
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-23-2005, 03:06 PM

Tags for this Thread

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