Results 1 to 3 of 3

A dymanic formula to return the expense for the current month

Threaded View

  1. #1
    Registered User
    Join Date
    06-20-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    24

    A dymanic formula to return the expense for the current month

    Attached is a summary tab and a data tab.

    I am trying to summarise the expenses for the current month. I don't want a sumif as this isn't dynamic. I want to be able to input the current month and have the formula check the data tab and sum all the expenses for the particular company and detail in the summary tab.
    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. Return Value for Current Month
    By HangMan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-31-2015, 06:45 AM
  2. Replies: 3
    Last Post: 10-11-2014, 09:04 PM
  3. How to return the current month given a specific value
    By SweetLD215 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-14-2014, 10:41 AM
  4. [SOLVED] Annual expense pasted in a specific month -- formula help
    By macrorookie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-22-2014, 09:49 AM
  5. [SOLVED] Date Formula to Return Week Number in Current Month based on Reporting Period
    By jeversf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2013, 12:10 PM
  6. Replies: 5
    Last Post: 10-04-2012, 07:06 AM
  7. Last 12 Month Dymanic Chart variation
    By discoverdean in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-29-2008, 12:10 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