Results 1 to 3 of 3

SUMPRODUCT & IF Statement Help!

Threaded View

  1. #1
    Registered User
    Join Date
    04-03-2020
    Location
    NYC
    MS-Off Ver
    365 Pro Plus
    Posts
    74

    Lightbulb SUMPRODUCT & IF Statement Help!

    Trying to layout a simple dollar accrual schedule.

    In my attached sample file w/ dummy data, there's 4 projects. Each project has 3 important dates, and 3 % accruals associated with each of those dates. Lastly each project has a whole revenue amount ($ - column 'L').

    I'm simply trying to create a 2021 timeline that checks the 3 dates, and multiplies the $ revenue by the accrual % on each specific date; dates A, B, C can be the same for projects, but in my example, each date is different.

    Right now I'm using this crazy formula I found online but it doesn't seem to be working - for example, I believe cell Z4 should output 20% of the $ revenue, but it isn't working.

    Any help would be great - I'm happy to quickly answer questions if needed.

    Thanks!
    Attached Files Attached Files
    Last edited by jk2391; 09-14-2021 at 10:28 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. SUMproduct If Statement
    By Sasquatch2014 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-16-2017, 12:21 PM
  2. [SOLVED] Sumproduct with OR statement
    By iLurk in forum Excel General
    Replies: 3
    Last Post: 12-03-2015, 11:46 AM
  3. [SOLVED] SumProduct Statement
    By Hudson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2013, 02:10 PM
  4. Sumproduct with an IF or AND statement
    By Kefo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-30-2013, 04:17 PM
  5. if statement for sumproduct
    By trentsim in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-29-2012, 01:54 PM
  6. Help with an SUM(IF(SUMPRODUCT Statement
    By jsgray in forum Excel General
    Replies: 3
    Last Post: 12-29-2010, 01:43 PM
  7. Sumproduct and If statement together
    By jsohng in forum Excel General
    Replies: 12
    Last Post: 09-02-2010, 05:30 PM

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