Hi all
Can somebody please help me with a formula/function.
Please find attached the document with a description in the comments.
Hi all
Can somebody please help me with a formula/function.
Please find attached the document with a description in the comments.
These will give you the count...
H3=COUNTIF($E$3:$E$402,H2)
I3=COUNTIFS($E$3:$E$402,">"&H2,$E$3:$E$402,"<="&I2)
copied across
For future reference, please ask ALL your questions IN the thread, that way members can see if they want to tackle your question, without needing to open files
It sounds like you want all the answers in 1 cell. If so, why is that? You will not be able to use any of the answers in any future formulas like that. Have you considered putting each calc in it's own cell, instead?Is there any way I can count the total number of people in this range and the other ranges from column F.
So that it appears in only row 3 for each respective range?
Is there also a function that can product and average of the total count for each range that would go in row 3 underneath the person count
And also a high low range beneath that?
What would some sample answers look like for the other questions, just so I understand what you want
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
Apologies I will do so from now on.
I made a typo in my explanation.
I meant to say:
Is there also a function that can produce an average of the total sum for each range relating to column B (This would go in H4 and be able to be dragged across until S4
i.e sum up and average all values in column B - from range 0 in column F
Then underneath that in H5 a formula that can be used to produce a high and low range from column B - from range 0 in column F that can be dragged over until S5
See attached the updated version of the file with your formula included.
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks