Results 1 to 2 of 2

Sumproduct - multiple criteria

Threaded View

missyreiber Sumproduct - multiple criteria 01-22-2010, 10:03 AM
JeanRage Re: Sumproduct - multiple... 01-24-2010, 05:09 AM
  1. #1
    Registered User
    Join Date
    07-16-2009
    Location
    MO, USA
    MS-Off Ver
    Excel 2003
    Posts
    39

    Sumproduct - multiple criteria

    I'm having a couple issues with the attached spreadsheet, not sure if it is user error or not.

    1. Cells V6:W6. This particular employee is a lower earner and the 11.3% is on the first $9,000 of income. After that is satisfied ($1017), then they get 17% on the rest of their income up to $41,137. The way it is showing now, this person is getting both but should only be getting the 11.3% because he has not maxed out yet.

    2. Cell U7 is showing a negative and I can't figure out why.

    I would love if someone would look at the worksheet and give their thoughts. Thanks so much!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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