Results 1 to 6 of 6

Convert SUMPRODUCT to SUMIFS

Threaded View

  1. 04-03-2017, 05:04 PM #5
    mlcb
    mlcb is offline
    Forum Contributor
    Join Date
    12-22-2010
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2010, 2016
    Posts
    209

    Re: Convert SUMPRODUCT to SUMIFS

    Maybe this works...

    =SUMIFS(JM$3:JM1083,A$3:A1083,">="&INT(A1083),A$3:A1083,"<"&INT(A1083)+1)+SUMIFS(JN$3:JN1083,A$3:A1083,">="&INT(A1083),A$3:A1083,"<"&INT(A1083)+1)+SUMIFS(JJ$3:JJ1083,A$3:A1083,">="&INT(A1083),A$3:A1083,"<"&INT(A1083)+1)

    M.
    Last edited by mlcb; 04-03-2017 at 05:10 PM. Reason: adjust ranges
    Marcelo Branco
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMIFS or SUMPRODUCT Help
    By QAGuy in forum Excel General
    Replies: 14
    Last Post: 03-17-2017, 02:06 PM
  2. [SOLVED] SUMPRODUCT with SUMIFS?
    By TPDave in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-25-2015, 04:30 AM
  3. [SOLVED] Convert SUMIFS formula to SUMPRODUCT
    By timbury1 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-08-2014, 01:18 PM
  4. [SOLVED] SUMPRODUCT(SUMIFS) How do I use them?
    By boon-yao.tek in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-20-2013, 05:10 AM
  5. sumifs or sumproduct
    By goodboy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-10-2013, 09:53 AM
  6. Sumifs Vs Sumproduct
    By _Lewis in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-21-2010, 11:28 AM
  7. Sumproduct/sumifs?
    By MjRmatt in forum Excel General
    Replies: 4
    Last Post: 07-30-2010, 08:09 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1