Conditional Quartile.INC function

[nzgin]

Hi guys,

Can you help me please? I require your Excel expertise

I have an ever-growing table with multiple columns like below:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Fruit
[/TD]
[TD]Numbers
[/TD]
[TD]Bag
[/TD]
[/TR]
[TR]
[TD]Orange
[/TD]
[TD]3
[/TD]
[TD]Yes
[/TD]
[/TR]
[TR]
[TD]Orange
[/TD]
[TD]2
[/TD]
[TD]No
[/TD]
[/TR]
[TR]
[TD]Apple
[/TD]
[TD]1
[/TD]
[TD]No
[/TD]
[/TR]
[TR]
[TD]Apple
[/TD]
[TD]1
[/TD]
[TD]Yes
[/TD]
[/TR]
[TR]
[TD]Apple
[/TD]
[TD]2
[/TD]
[TD]Yes
[/TD]
[/TR]
[TR]
[TD]Apple
[/TD]
[TD]3
[/TD]
[TD]Yes
[/TD]
[/TR]
[TR]
[TD]Apple
[/TD]
[TD]2
[/TD]
[TD]No
[/TD]
[/TR]
</tbody>[/TABLE]

I want to use the QUARTILE.INC function for apples only.

How do I format the function to filter Column A for Apple and to use Apple's Numbers only? Remember, the table grows steadily.

=QUARTILE.INC(ARRAY, QUART)

 

[nzgin]

Hey guys,

No solutions? Or, the only solution is to create another table for Apple only?