Results 1 to 7 of 7

Need help in Excel SUMIFS + MATCH

Threaded View

  1. #1
    Registered User
    Join Date
    10-24-2011
    Location
    Puducherry, India
    MS-Off Ver
    Excel 2003
    Posts
    3

    Need help in Excel SUMIFS + MATCH

    I want to calculate the total rent for the complex where at least one room is occupied.

    i.e for example the condition would be Apartment Complex, say "Mountaintop View" from Summary Statistics is present in Apartment complex of "List of Rental Property" and also if at least one room is occupied (MATCH("Yes",F14:F26,0) = 1 ) then I need total rent to be calculated. In the given example it would be 3025(875+950+1200).

    I have tried using SUMIFS + index + Match. however i didn't get the output i need, May be because i am using the wrong method.

    I want this to be calculated and placed in 'potential rent'. and would like to be calculated for all the complex in the 'Summary Statistics' table.

    Need help in this issue.
    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