+ Reply to Thread
Results 1 to 3 of 3

SUMPRODUCT formula does not tally with manual SUM

  1. #1
    Forum Contributor
    Join Date
    09-19-2017
    Location
    London
    MS-Off Ver
    2015
    Posts
    169

    Question SUMPRODUCT formula does not tally with manual SUM

    Hi, all

    I have this one Excel file with data based on dates and time. I want to sum up the cost for a certain period (daily basis). Tried to use:

    SUMPRODUCT(--(A$3:$A$581>=J11),--($A$3:$A$581<=K11),$E$3:$E$581)

    But when I manually sum up the cost, it gives different answer.

    Any part that is wrong in my formula? I have attached a test workbook for better understanding.

    Looking forward to any feedback. Have a nice day!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,803

    Re: SUMPRODUCT formula does not tally with manual SUM

    It's because the date/time in cell A123 is not exactly right. If you select that cell, then change the format to "General" and look in the formula bar, you will see:
    43932.0000000003
    and it should be just 43932.
    Once that date is corrected, you'll get the same answer.

  3. #3
    Forum Contributor
    Join Date
    09-19-2017
    Location
    London
    MS-Off Ver
    2015
    Posts
    169

    Re: SUMPRODUCT formula does not tally with manual SUM

    Ahh got it. Thanks!

+ 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. Simple Tally Formula
    By mrJusto in forum Excel General
    Replies: 3
    Last Post: 01-22-2020, 05:40 PM
  2. Formula to tally a certain value IF bold
    By Beh162 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-26-2016, 07:54 PM
  3. Help with SUMPRODUCT formula to tally all values
    By relmasri in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2016, 04:09 PM
  4. [SOLVED] Need help with a tally formula
    By alanls1987 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-11-2013, 07:55 AM
  5. formula look up deleting duplicates and tally
    By ellenpost in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-20-2013, 10:22 AM
  6. Replies: 6
    Last Post: 10-03-2012, 06:18 AM
  7. create tally sheet for positions- insert names and tally #
    By tally sheets in forum Excel General
    Replies: 0
    Last Post: 04-11-2006, 04:45 PM

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