LinkBack URL
About LinkBacks
My problem is the exact same as: http://www.excelforum.com/excel-gene...ifs-match.html
This is the answer they came up with: (COUNTIFS($B$14:$B$26,A6,$F$14:$F$26,"Yes")>0)
However, if I type this in, I get the answer FALSE instead of a number...
My problem is the exact same as: http://www.excelforum.com/excel-gene...ifs-match.html
This is the answer they came up with: (COUNTIFS($B$14:$B$26,A6,$F$14:$F$26,"Yes")>0)
However, if I type this in, I get the answer FALSE instead of a number...
Did you try =COUNTIF($B$14:$B$26,A6,$F$14:$F$26) before adding the other variables to the "COUNTIFS" ? Looks like it should work and if you want to use countifs( ) you need additional variables from what you show. Keep trying, You'll get it!
Good Luck,
Last edited by Tank997; 03-10-2013 at 08:54 PM.
Tom S.↙ If you find my reply helpful click on the * down there on the left. Yeah that's it, right there, down on the leftIf your question is resolved, mark it SOLVED using the thread tools.
The formula returns a value of TRUE or FALSE because it is using a comparison operator to test if the result of the COUNTIFS is greater than zero. It either is greater (TRUE) or not (FALSE).
Assuming you adjusted the formula for cell ranges and criteria you just need to drop the first parenthesis and this part of the the formiula: >0)
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
I tried that. When I removed the parenthesis the equation came up with $1 as the potential rent and there's no way that's right...Originally Posted by Palmetto
A great reason to upload an example file if you can without revealing any personal data.
Exploring_e07_Grader_EOC.xlsx
Here's the document. I'm trying to find the potential rent
My understanding from the Excel. You need to calculate potential rent based on total occupancy. The formula for Cell F6 should be
Also you are calculating % Potential Rent. For this you are taking Potential Rent/Actual Rent. I believe you need to take Actual Rent / Potential Rent.
Please Login or Register to view this content.
I thought it was that too but if you type that equation in that gives you $1,750 for the potential rent for Lakeview Apartments. Except potential rent is supposed to be based off occupancy and that first one doesn't have any occupants...does that make sense?
ALSO! Thank you for this clarification!
If your query is solved, can you please mark it as solved and also click "*" at the bottom of post to add this to my reputation
Still don't know what the right equation is for the potential rent.
Not sure what your latest workbook looks like, but ...
In F6: (potential rent)
Formula:
Please Login or Register to view this content.
Drag/Copy down to F10
In G6: (Actual rent being recieved)
Formula:Please Login or Register to view this content.
Drag/Copy down to G10
In H6: (% of potential rent)
Formula:Please Login or Register to view this content.
Drag/Copy down to H10
In G11: (total rent recieved)
Formula:Please Login or Register to view this content.
(see attachment for visualization)
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Potential rent = total rent price for every type of apartment?
if yes then use tqsekhar formula on #7
and for % of Potential Rent = Actual Rent / Potential Rent.
If you not satisfied with that, can you provide how you count the Potential Rent?
See attachment
Click (*) if you received helpful response.
Regards,
David
solution for this question
In cell E6, insert a function that will rank the value in D6 based on the occupancy rates of all five apartment complexes, in descending order. Enter the range as an absolute reference. Copy the function down through E10.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks