Results 1 to 6 of 6

Convert SUMPRODUCT to SUMIFS

Threaded View

  1. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Convert SUMPRODUCT to SUMIFS

    All the xxIF functions require ranges as arguments in certain positions, so you can't perform those INT functions, e.g.,

    =SUMIF(INT($A$3:$A1083), INT($A1083), JM$3:JM1083)

    ... won't work.

    I don't use Office365, but am certain that nothing has changed to make that formula not work. I expect you have an errant value in one of those ranges.
    Last edited by shg; 04-03-2017 at 02:59 PM.
    Entia non sunt multiplicanda sine necessitate

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1