+ Reply to Thread
Results 1 to 2 of 2

Multiple IF Statement - nested IF, Sumproduct...

Hybrid View

  1. #1
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Multiple IF Statement - nested IF, Sumproduct...

    Hi
    Try this formula in C3 and copy down and right
    Formula: copy to clipboard
    =SUMPRODUCT(--('Budget Entry'!$I$2:$I$10=C$2)*('Budget Entry'!$B$2:$B$10=$A3)*('Budget Entry'!$G$2:$G$10=$B3)*'Budget Entry'!$J$2:$J$10)


    Note: I made same modification on your layout to allow copy down and right

    See the file
    Attached Files Attached Files

+ 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. [SOLVED] Multiple IF Statement - nested IF, Sumproduct...
    By 1Stacy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-14-2016, 12:37 PM
  2. [SOLVED] Multiple Nested IF Statement error
    By Seth_ in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-03-2016, 12:54 PM
  3. Multiple if Nested Statement
    By slohman in forum Excel General
    Replies: 3
    Last Post: 07-18-2016, 07:53 PM
  4. Nested IF statement error. Nested True statement is not triggering
    By Lucas7040 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-26-2016, 11:41 AM
  5. Sumproduct function with a nested if statement looking at multiple criteria
    By storkhiw in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-20-2016, 10:31 AM
  6. Replies: 2
    Last Post: 07-09-2015, 04:25 PM
  7. IF Statement required. (Nested or Multiple)
    By singerbatfink in forum Excel General
    Replies: 2
    Last Post: 09-28-2010, 06:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1