+ Reply to Thread
Results 1 to 3 of 3

SUMIFS = summarise data by currency amount and date combo

  1. #1
    Registered User
    Join Date
    03-25-2020
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    51

    SUMIFS = summarise data by currency amount and date combo

    Hello

    Bit stuck on how to use sumifs to sum up all currency values by day into the front sheet. I've given it a go in C3 in front sheet but need a hand clearly!

    So 1st tab = is where I want the formula to work and populate values. Currency criteria should be based on currency range in col B6 onwards in second tab. Date criteria should be based on row 2 (D2 onwards) in second tab.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,458

    Re: SUMIFS = summarise data by currency amount and date combo

    Like this ?
    Attached Files Attached Files
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

  3. #3
    Registered User
    Join Date
    03-25-2020
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    51

    Re: SUMIFS = summarise data by currency amount and date combo

    Quote Originally Posted by Pepe Le Mokko View Post
    Like this ?
    Perfect. I've added in IFERROR to take care of the NAs (which is down to no weekends on the Data tab)

+ 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. SUMIFS figuring hourly rate based on date and amount made
    By rothe31 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-04-2020, 04:15 PM
  2. don't get the value ... when cell has $ before amount of currency
    By incobart in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-10-2017, 10:15 AM
  3. Summarise data by date
    By mawallace in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-07-2017, 12:43 PM
  4. Replies: 11
    Last Post: 07-12-2015, 08:50 PM
  5. Summarise data based on date
    By ks04 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 10-08-2013, 10:54 AM
  6. Replies: 2
    Last Post: 04-28-2013, 02:23 AM
  7. Replies: 2
    Last Post: 02-17-2009, 11:35 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