How to count numbers in a column based on a set of numbers

I have a set of numbers (2,4,0) and (5,17,10). Column F outputs true if the subsequent numbers in column A belong to the same set of numbers. Column G returns numbers in column B if cells in F are true. Column Q counts the values in the G based on the numbers in P. Their percentages are calculated using the formula

Formula:

Please Login or Register  to view this content.

I want to calculate the percentage based on the set of numbers mentioned above. Therefore I need a formula that can count values in G on condition that cells in column F are TRUE and if numbers in column A are in same set. The expected output is in column S and T however these should output one at a time. So in my example, because 5 which the last number in column A that belongs to one set, I would like to see 50% and 50% only. if the last number in column A was 0, i would see just 33.33%,33.33% and33.33% only. I wouldn't want them in separate columns . This was asked in Mr.Excel but no response.
Thanks

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...mbers.1221613/)

Thank you for the correction as I am new here, I wasn't aware of that rule. I hadn't receive an answer that's why I came here. I would not repeat that again. Thanks

However, you did tick to say that you had read and understood our rules when you joined today ...

Have a read of them now, please.

Please read post #2 carefully: in it, I explained that I would provide the link for you this time. This I did. There is NO instruction that prevents anyone from responding.

Please be patient.

I don't understand what "I wouldn't want them in separate columns" means, so if the results are not where you want them, please attach another file that will illustrate that part of the request.
The following formulas replicate the values seen in columns S:T
For column S: =SUMPRODUCT(((A$1:A$20=2)+(A$1:A$20=4)+(A$1:A$20=0))*(A$1:A$20<>"")*(G$1:G$20=P4))/SUMPRODUCT(((A$1:A$20=2)+(A$1:A$20=4)+(A$1:A$20=0))*(A$1:A$20<>"")*(G$1:G$20<>""))
For column T: =SUMPRODUCT(((A$1:A$20=5)+(A$1:A$20=17)+(A$1:A$20=10))*(A$1:A$20<>"")*(G$1:G$20=P4))/SUMPRODUCT(((A$1:A$20=5)+(A$1:A$20=17)+(A$1:A$20=10))*(A$1:A$20<>"")*(G$1:G$20<>""))
Note that both columns are custom formatted using: 0.00%;;
Let us know if you have any questions.

Looking at the file attached to post #1, and according to the information in post #10, should cells S5 and S7 display 50%?