+ Reply to Thread
Results 1 to 4 of 4

Cell referencing question?

  1. #1
    Registered User
    Join Date
    04-04-2017
    Location
    Amman
    MS-Off Ver
    2010
    Posts
    2

    Cell referencing question?

    Hello all,

    I need to identify an amount entered by a specific date in the "daily" sheet to its location in the "monthly" sheet..

    How could i do this?
    Attached Files Attached Files

  2. #2
    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
    52,938

    Re: Cell referencing question?

    Hi, welcome to the forum

    care to explain, in more detail, what you are doing and 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

  3. #3
    Registered User
    Join Date
    04-04-2017
    Location
    Amman
    MS-Off Ver
    2010
    Posts
    2

    Re: Cell referencing question?

    I need to enter a transaction in the general ledger that it classified directly by month and date in the calendar

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,061

    Re: Cell referencing question?

    is this what you mean? In monthly C3, copied down and then into the other boxes.

    =SUMIF(Daily!$C:$C,Monthly!B3,Daily!$B:$B)

    or if you don't want to see all those zeros...

    =iferror(1/(1/SUMIF(Daily!$C:$C,Monthly!B3,Daily!$B:$B)),"")
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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. Cell referencing formula question
    By mickbowler in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-12-2014, 09:19 AM
  2. Formulas and cell referencing question
    By DemolitionX in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-04-2013, 04:29 PM
  3. Cell Referencing question
    By Ishdent in forum Excel General
    Replies: 6
    Last Post: 11-03-2011, 05:50 PM
  4. Cell Referencing Question
    By Impartial Derivative in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-29-2011, 12:58 PM
  5. Lookup referencing cell referencing range
    By cmcconnehey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-15-2008, 06:19 PM
  6. INDIRECT cell referencing question.
    By call_me_bob in forum Excel General
    Replies: 7
    Last Post: 04-03-2007, 09:21 PM
  7. Odd question re: cell referencing
    By bindak in forum Excel General
    Replies: 1
    Last Post: 10-17-2006, 03:59 PM
  8. [SOLVED] Another question re cell referencing.
    By rmellison in forum Excel General
    Replies: 0
    Last Post: 09-23-2005, 08: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