Results 1 to 16 of 16

If function with Sumifs

Threaded View

  1. #1
    Registered User
    Join Date
    06-04-2021
    Location
    London
    MS-Off Ver
    2016
    Posts
    30

    If function with Sumifs

    Hi team,

    Could someone please assist to help me pull through the actual or forecast for specific month on my expected result-so at any time when the actual or forecast changes by moving the cell from the source data my result tab will update.
    On the if statement formular my value if criteria should only pick the sum of forecast for specific month if it is not actual.

    Thanks for all your support.
    John
    Attached Files Attached Files
    Last edited by Johnyam54; 07-05-2024 at 07:03 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. SUMIFS Function
    By viewotst in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-15-2021, 08:05 PM
  2. [SOLVED] Using TODAY function inside the SUMIFS function
    By taraberg_321 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 04-26-2019, 10:32 AM
  3. [SOLVED] Merge Month function in SUMIFS function
    By wincross in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 07-28-2017, 09:08 AM
  4. sumifs function help
    By Rebien in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-08-2015, 12:54 PM
  5. [SOLVED] Using large function based on sumifs function
    By jeosen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-26-2015, 08:20 AM
  6. Help nesting an OR function inside a SUMIFS function
    By wes228 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-21-2014, 06:22 PM
  7. SUMIFS function
    By mmmarks in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-12-2013, 09: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