Results 1 to 10 of 10

Multiple Sum Ifs by month

Threaded View

  1. #1
    Registered User
    Join Date
    07-07-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    2010
    Posts
    68

    Question Multiple Sum Ifs by month

    Hi All,
    Some of you may recall I had this problem with quarterly data recently.
    i thought I'd be able to copy it monthly but no such luck - please help I'm not sure what i am doing wrong?

    I have some criteria within my data entry (Budget Entry) tab and I'd like to sum all of the totals.
    If the subproject code (7 digits) begins with 230 or 280 AND the month is 4 I'd like all entries to sum under April.
    or quarterly data I was using Sumproduct and then a ROUNDUP/3 function to get teh data to display in quarters - this works perfectly, but it is not transferrably to months - should i use SUMIFS?

    For quarters I am using:
    SUMPRODUCT('Budget Entry'!$Q$2:$Q$200*((LEFT('Budget Entry'!$F$2:$F$200,3)="230")+(LEFT('Budget Entry'!$F$2:$F$200,3)="280"))*(ROUNDUP('Budget Entry'!$N$2:$N$200/3,0)=COLUMNS($H7:I7)))
    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] Calculation of days per month for dates beginning in one month and ending in another month
    By Fahrettin in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-07-2015, 04:52 PM
  2. [SOLVED] Multiple lines per month need to collate
    By mylittlebookkeeper in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-07-2015, 07:20 AM
  3. [SOLVED] Determine work days in current month or next month based on day of the month
    By sbrnard in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-29-2014, 05:14 PM
  4. [SOLVED] Counting & summing formula (until last month,this month,until this month..
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-12-2014, 01:14 PM
  5. [SOLVED] Auto instert Month names for This month, Last month and Next month
    By hemal89 in forum Word Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2013, 12:01 PM
  6. How to create multiple month to date summaries from multiple worksheets
    By cmwilbur in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2010, 02:56 PM
  7. same month/day on x axis for multiple years
    By mjo73 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-15-2006, 02:25 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