Hi I thought I had finished this spreadsheet, but i've just noticed an error
Blank AnalysisHELP4.xlsx
My G column on the Data Analysis tab doesn't seem to be working out the results correctly; for example G19 should be showing the number of mid-level ability males making "above" expected progress and when I look at the Info tab the number should be 3 and not 4 as shown in the cell.
All help is appreciated
Your parentheses aren't correct - try this version
=SUMPRODUCT((INDEX(Info!$A$2:$AO$39,0,MATCH("Gender",Info!$1:$1,0))="M")*(INDEX(Info!$A$2:$AO$39,0,MATCH("Ability Level",Info!$1:$1,0))="mid")*(INDEX(Info!$A$2:$AO$39,0,MATCH("KS2-3 Progress4 Y7 Spring 2",Info!$1:$1,0))="Above"))
Audere est facere
Great thank you! I will try it in the morning and let you know how I get on
You can make the formula slightly more generic too ...
Formula:
Please Login or Register to view this content.
It's spaced out so it's easier to see how the sections compare.
See the updated example
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Wow that works perfectly! Thank you very much for your help!
You're welcome. Thanks for the rep.
Does this mean that I have wasted my time answering here?
http://www.excelforum.com/excel-form...r-heading.html
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
@AliGW: looks that way
Regards, TMS
No, and no credit was given there, either. Should we go there and post a link to this one to prevent anyone else wasting their time?
Should we go there and post a link to this one to prevent anyone else wasting their time?
I doubt that anyone else will join in on that thread to offer a solution but it might make sense to close the loop. And maybe suggest, politely, that it is actually the OP's responsibility to do that, and mark the thread as solved. Of course, he's going to get that prompt from this dialogue ...
Regards, TMS
Hello codyryan,
In line with the responses here can you please mark "Solved" any of your threads that are in fact solved.
In future it's normally better to keep all related questions in one thread to avoid issues whereby different people are trying to answer the same question in separate threads, with potentially none of them having the full picture. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks