Results 1 to 8 of 8

COUNTIFS and SUMPRODUCT help

Threaded View

  1. #1
    Registered User
    Join Date
    07-18-2013
    Location
    Indianapolis, IN
    MS-Off Ver
    Standard 2010
    Posts
    3

    COUNTIFS and SUMPRODUCT help

    I am trying to figure out how to make a cell diplay a sum of other cells in the worksheet IF they meet 2 criteria found in other columns. So for example, Column A displays loan amounts, Column B shows interest rates, Column C shows terms. I want a seperate cell in the worksheet to search columns B and C and if both criteria are met then sum the amounts from column A.
    Loan Amounts Rate Term
    155,000 3.25 360
    125,600 4.0 360
    265,000 3.25 120
    189,500 3.25 360

    I want a cell somewhere else in the worksheet that would show a result of 344,500 (amounts from column A that meet both criteria of 3.25 AND 360, summed)
    Any help would be appreciated!
    Last edited by Stacy1; 07-19-2013 at 10:11 AM. Reason: admin told me to

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 10-08-2009, 03:45 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