LinkBack URL
About LinkBacks
Post revised (refer to 04:41am post below). Apologies for any inconvenience caused.
Post revised (refer to 04:41am post below). Apologies for any inconvenience caused.
Last edited by ceishue; 12-10-2016 at 05:59 AM.
The COUNTIFS are correct.
It's not clear to me why you say the count of "Talks by ITEs/ JCs/ Polys" for instance is 22. That may be the number in J253, but there are only 19.
There's also a typo with one of the "Learning Journeys to ITEs/ JCs/ Polys" records which is spelled differently in C192, i.e. "L earning Journeys to ITEs/ JCs/ Polys" with a space after the first 'L'
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks Richard, for your input! I re-did the sample doc as attached and still can't tally the totals for D19 & E19 (removed dummy count due to human error) to 231 (paxs) unfortunately.
If you require further help with this, please remove the SOLVED tag from the header of your opening post.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
oh ok
To any one who can help, I was too hasty to conclude the issue earlier. After redoing the doc as attached, I still can't get the total in E19 to tally as well as to tally the totals for C19 and H19.
Thanks!
------------------
Separately...
Having surveyed participants on 13 preferred work industries, results were returned in a text string in a cell per pax, eg:
Built Environment (e.g. construction, landscaping), Business (e.g. entrepreneurship), Law, Public Safety and Security, Entertainment & Arts (4 industries chosen)
Have used countif, eg. =countif(range,"*Business*") to obtain the total occurrences of each industry which adds up to an overall total. Wonder if there is another formula to do so, for me to verify individual/overall totals?
Last edited by ceishue; 12-10-2016 at 05:54 AM.
That's because at least one of your descriptions on the Group2 sheet isn't present on sheet 2.
i.e. " eCareers portal*"
Note the space characters after the " character
I can't help thinking you'd be better advised to re-organise your data into a normalised table that a Pivot Table could use and analyse the data with a Pivot Table.
Hi Richard, thanks for your input once again. I did spot the typo and revised it in the latest attachment (04:41am) so only the '2ng Ranked' total is not tallying up to 231 (230 instead) now. When I cross-checked the totals throughout 1st to 3rd rank for each item against that of the Overall Column, some values did not tally too.
I'm not that familiar with Pivot tables and probably have to look it u
Hi,
The basic problem is that in some places you're counting a phrase that doesn't exist in one of the ranking columns.
For instance B91 contains "work shadowing, but none of the C91:E91 contain that phrase
Similarly with 'Talks by school' which exists in B211 but not in C211:E211
I've not checked them all but no doubt there are similar differences elsewhere
The moral is to compare like with like. You should also use the wildcard character carefully.
See attached:
Typos!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks