Results 1 to 17 of 17

sum of item by mnth

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-12-2014
    Location
    Dubai U A E
    MS-Off Ver
    office 365
    Posts
    105

    sum of item by mnth

    Hi
    I have 2 worksheet 1 cash flow the second one g journal . In the G job1urnal sheet column B is dates c desc d column debit e column credit and f column amount. the cash flow sheet column b has various items starting from b13 to b19 and row d 2 onwards are dates . what I am trying to do is to check the g journal sheet for items in column e that matches cashflow sheet row b13 to b19 , then tax items in column d of the journal matches b12 of the cash flow and then for the period in the g journal in column b the month that matches the row 2 of the cash flow. eg the row highlighted in red (row 82) shows the date as 12-apr-23 in the b column tax in the d column capital mall in e column and 1000 in the f column. as these match with the row b19 in the cash flow the amount of 1000 is shown in d 19. I tried the sumifs but could not geet the desired result. any suggestions
    Shamsu
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] add specific item into last item for whole item based on where precede item
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-28-2022, 03:25 PM
  2. [SOLVED] Issues with Macro to create individual pdf files for each item on item validation list
    By maldo81 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-10-2021, 02:58 PM
  3. Replies: 5
    Last Post: 03-01-2017, 05:41 PM
  4. UserForm: Search Item in List > Call Table associated with Item > Execute Command
    By TexasAggie12 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2014, 12:58 PM
  5. Taking the next item in a list into 1 of 2 tables based on the previous item time
    By SoleAris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-07-2011, 04:59 PM
  6. Replies: 1
    Last Post: 05-03-2006, 05:25 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