Results 1 to 5 of 5

Need a sum formual with 2 critera and count

Threaded View

  1. #1
    Registered User
    Join Date
    01-15-2010
    Location
    Scottsdale
    MS-Off Ver
    Excel 2010
    Posts
    72

    Need a sum formual with 2 critera and count

    I am looking for a sum formual that will sum Month To Date data for current year prior year. I am currently working with sumifs because I need two sum criteria, the Year and Month. Issue that I am having is currently I have 4 weeks of September data for 2014 so I would only want to sum the same 4 weeks of September data from 2013. A straight sumifs for 2013 will not work because I would pick up the 5th Sept week from 2013 that currently has not happended in 2014 so I would be comparing 5 weeks to 4. I know I can accomplish what I need with offset() formulas but I am trying to stay away from them. Any suggestions? Example attached.


    Thank you,
    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. How to add Count function to existing Formual
    By cartica in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-14-2013, 03:52 PM
  2. Count across multiple columns with two critera
    By ucirsharma in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-20-2013, 01:26 PM
  3. Count with two critera
    By mwrfsu in forum Excel General
    Replies: 2
    Last Post: 08-01-2007, 09:14 PM
  4. Count if the the critera is met then half it
    By Joel in forum Excel General
    Replies: 5
    Last Post: 01-09-2006, 02:10 PM
  5. [SOLVED] count G4:G51 for critera only if D4:D51 contains text data
    By sir Lancelot in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-13-2005, 04:00 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