Results 1 to 16 of 16

If function with Sumifs

Threaded View

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

    Re: If function with Sumifs

    HI John,

    Thanks for coming back to me.
    Could you please amend/update my formular --=IF(B$3="Actual",SUMIFS($B14:$M14,$B$3:$M$3,"Actual"))

    I want to sum the actual and forecast separately.

    Actual spend todate 98000
    Forecast remaining to spend FALSE

    Thanks
    Last edited by Johnyam54; 07-05-2024 at 07:12 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