Results 1 to 7 of 7

SUMIFS formula returns value 0

Threaded View

  1. #1
    Registered User
    Join Date
    08-07-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    8

    Unhappy SUMIFS formula returns value 0

    Greetings,

    I hope community members and their loved ones are safe and healthy.

    I use the following formula to match and paste values to a different sheet automatically. I am creating automation to help manage my monthly finances.

    =SUMIFS('2023_2024_icici_parth'!$H$2:$H$1486, '2023_2024_icici_parth'!$H$2:$H$1486, "> 0", '2023_2024_icici_parth'!$F$2:$F$1486, "Salary", '2023_2024_icici_parth'!$B$2:$B$1486, ">="&'2023_2023_calculations'!C$1, '2023_2024_icici_parth'!$B$2:$B$1486, "<" & '2023_2023_calculations'!D$1)
    I have checked the following (and uploaded a sample sheet with data)
    1. Ensured that the data in columns B, F, and H of the 2023_2024_icici_parth sheet was in the correct format (i.e., dates in column B, text in column F, and numbers in column H).
    2. Check that the values in cells C1 and D1 of the 2023_2023_calculations sheet are valid and within the range of dates in column B of the 2023_2024_icici_parth sheet.
    3. Verify that there are rows in the 2023_2024_icici_parth sheet where the value in column F is ?Salary?, and the value in column H is greater than 0.


    However, I am still getting 0 as the output.

    I used the COUNTIFS to diagnose

    =COUNTIFS('2023_2024_icici_parth'!$H$2:$H$1486, ">0", '2023_2024_icici_parth'!$F$2:$F$1486, "Salary", '2023_2024_icici_parth'!$B$2:$B$1486, ">="&'2023_2023_calculations'!C$1, '2023_2024_icici_parth'!$B$2:$B$1486, "<" & '2023_2023_calculations'!D$1)
    I am still getting 0

    Could I please request assistance from the forum?
    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] sumifs/sumproduct formula returns error or zero
    By adsako in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-26-2018, 03:06 PM
  2. [SOLVED] sumifs/sumproduct formula returns VALUE error
    By adsako in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-01-2018, 08:17 AM
  3. IFERROR(SUMIFS returns 0 and not the alternate formula?
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-24-2017, 11:00 AM
  4. USING SUMIFS formula returns a '0' for me
    By jlp83 in forum Excel General
    Replies: 7
    Last Post: 03-12-2015, 06:53 AM
  5. [SOLVED] sumifs formula returns error
    By kronikjb in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-08-2015, 12:51 PM
  6. Sumifs formula returns ZERO
    By Xx7 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-10-2013, 02:05 PM
  7. SUMIFS returns VALUE!
    By mogdog1981 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-03-2011, 04:38 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