+ Reply to Thread
Results 1 to 15 of 15

I have applied IF to 5 cells that work but one wont

Hybrid View

  1. #1
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,050

    Re: I have applied IF to 5 cells that work but one wont

    1st, you have a circular reference error in your sheet - that is when a formula in a cell, references the cell it resides in.
    A quick check tells me that on sheet Overview, you have
    K10=SUM(K4:K10)
    As you can see, K10 is referencing itself in that formula. It should be
    =SUM(K4:K9)
    The same is happening in at least L10

    2nd, you would be far better served if you have ALL data on 1 sheet, rather that a sheet per month. This will make all summaries much simpler.

    3rd, please show some sample data, and expected outcome, so we know what you want
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  2. #2
    Registered User
    Join Date
    03-18-2019
    Location
    South East Asia
    MS-Off Ver
    excel online
    Posts
    7

    Re: I have applied IF to 5 cells that work but one wont

    Thank you for checking on this it is very helpful having help like this

    I am trying to create a basic cashflow management / distribution log excel template.

    It is just a logbook of petty cash expenditures with a drop down menu and then on the overview page I would like it to give the report based on the dropdown menu and the date.
    How can I best do that?

    Thank you again, this forum is extremely helpful.

+ 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: 2
    Last Post: 01-31-2018, 08:49 AM
  2. Code wont work if the first cells are empty
    By KyleJackDaniels in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2016, 10:10 AM
  3. Replies: 2
    Last Post: 03-03-2016, 06:27 PM
  4. Why wont max work on cells that have a formula
    By leedsexcel in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 11-23-2007, 02:31 PM
  5. [SOLVED] Cells.Find wont work with "-"
    By alan_conoco@hotmail.co.uk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2006, 10:20 AM
  6. Why wont it work?
    By Bobby in forum Excel General
    Replies: 6
    Last Post: 12-01-2005, 08:55 PM
  7. Anyone know why this wont work?
    By Mark Stephens in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2005, 02:05 AM

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