Results 1 to 4 of 4

sumifs formula not function properly???

Threaded View

  1. 08-16-2022, 03:33 AM #1
    yiyi2
    yiyi2 is offline
    Registered User
    Join Date
    05-14-2018
    Location
    Hong Kong
    MS-Off Ver
    MS 365
    Posts
    82

    sumifs formula not function properly???

    Here is my workbooks
    sheet "Master" column D, E, F, G formulas are set (to sum up value from tab "Gross Sales")
    It seems formula is function but only partial of data are calculated.

    For eg

    Column A - almond - column D-G are calculated.
    but ginger value are not generated.

    it seems the upper half of the worksheet is calculated properly but the bottom half isn't. What is wrong with my formula?
    Last edited by yiyi2; 08-19-2022 at 04:22 AM.
    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. SUMIFS function & formula
    By timstring in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-08-2019, 05:05 PM
  2. SUMIFS Formula does not calculate properly
    By Joey de Leon in forum Excel General
    Replies: 4
    Last Post: 09-06-2017, 04:31 PM
  3. [SOLVED] IF Function Does Not Calculate Properly When Adding a 3rd IF formula
    By EverClever in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 07-15-2017, 07:48 PM
  4. [SOLVED] SUMIFS formula not working properly
    By fahadmohsin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-16-2016, 12:03 PM
  5. Sumifs formula is not working properly
    By Sanjibghosh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-28-2016, 02:58 AM
  6. SUMIFS not working properly
    By drowe005 in forum Excel General
    Replies: 5
    Last Post: 03-29-2016, 07:14 PM
  7. Auto-complete formula function doesn't work properly
    By malahe in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-18-2014, 10:04 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1