Dear All,
Please solve attached item
Dear All,
Please solve attached item
is this a homework question ?
it appears to be an assignment to me and i prefer not to do your homework or assignments - it best that you learn how to do this with assistance rather than get a solved spreadsheet
Happy to assist you learning how to do it , and to this end
what have your tried to do using the countifs()
what results did you get
Do you know the difference between an Absolute and a Relative Address, if so please explain on a post what the difference is just using the excel cell reference
Last edited by etaf; 03-23-2017 at 03:30 AM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Dear Sir,
Please help me in this regard. I solved another questions.
happy to help
but as i said
lets look at the first countifs()what have your tried to do using the countifs()
what results did you get
Do you know the difference between an Absolute and a Relative Address, if so please explain on a post what the difference is just using the excel cell reference
upper limit <=4 is in Cell A7
lower limit >3.5 is in cell B7
datarange is from A14 to A24
=countifs( criteria_range1, criteria1, criteria_range2, criteria2)
what would you use in Cell C7
Last edited by etaf; 03-23-2017 at 03:59 AM.
Dear Sir,
C7 will show the result
yes it will
But only if you type in a function , what function should you type in
I'm not going to answer this for you , as i'm sure its a homework - you really need to learn how to do it, and i will help
so i want to see given i have laid out all the info you need
what would you type into cell C7 to get the result
we can start with =countifs(
then you can see in the previous post, quoted below what the function countifs() requires
I also asked if you knew=countifs( criteria_range1, criteria1, criteria_range2, criteria2)
upper limit <=4 is in Cell A7
lower limit >3.5 is in cell B7
datarange is from A14 to A24
what would you use in Cell C7
do you?Do you know the difference between an Absolute and a Relative Address, if so please explain on a post what the difference is just using the excel cell reference
if so what is the difference in excel function terms ?
Dear Sir,
I tried but I cant do that. Please help me. I will glad if u help me.
i know you have tried
What have you actually tried , is all i'm asking and why
I'm not going to do it for you , as its homework or an assignment
when do you have to have the assignment in ?
can you also answer the question regarding relative and absolute addressing
sorry to be hard on you - but you will have to do this on your own at some point in the future or during an exam
What should the result be in C7
whats the actual answer a function should return ?
Last edited by etaf; 03-23-2017 at 04:46 AM.
Dear Sir,
I will learn future from you. But I need help in this regard. Once you help me I will learn it forever.
ok, thats great
and i will be more than happy to assist you in learning
to that end - you do need to answer the questions I have posted
what should the answer actually be in the cell C7 , how many of the range meet those criteria ?
what do you know is the difference between absolute and relative addressing and how does excel tell the difference in a formula
What would you actually type into cell C7 to get the answer
if you just want the answers without doing any work at all, then i'm sorry, but i'm afraid i'm not going to do that for you.
Dear Sir,
Please help me. Please please. I just wants to submit post within 4 PM. Then i will learn. Now time is almost 2.56 PM Bangladesh time.
answering some of my questions earlier would have speeded things up a lot
7:27 UK time
13:30 your time
so please would answer my questions
if you do not know any of the answers to my questions
then have a look at some websites
http://www.contextures.com/xlFunctions04.html
http://blog.contextures.com/archives...iple-criteria/
I'm really sorry, but I'm not going to provide the answer for an assignment
you have not even answered what the cell C7 result should show
is it 1 or 2 or 3 or ?????
Last edited by etaf; 03-23-2017 at 05:13 AM.
azmir, Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).
We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.
If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks