A Index match match or Lookup with certain criteria

[Naicker]

Hello,

I have a program which spits out data formatted like the table shown below (the real table is hundreds of lines long).

I want to find the frequency of certain headings such as "Pears a", however I am having trouble as the 2 variables 'pears' and 'a' are in the same column.
And to make it more difficult, variables such as 'a' are repeated in the table.

Any Ideas?

 

[PCL]

"like the table shown below" .... nothing is shown

 

[Naicker]

"like the table shown below" .... nothing is shown

There is a picture, but maybe it didn't load properly. ill try again, please see below:

[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]Apples[/TD]
[TD]Frequency[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Pears[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]6[/TD]
[/TR]
</tbody>[/TABLE]

 

[Naicker]

I should also note that the position of Pears, Oranges, etc in column A will vary in the future.

 

[PCL]

What's up if exists several Pears a ??

 

[PCL]

Assuming D4 = Oranges and E4 = a
H4=INDEX($B$1:$B$1000,MATCH(D4,A$1:A$1000,0)+MATCH(E4,OFFSET($A$1,MATCH(D4,A$1:A$1000,0),0,10000,1),0),1)

 

[Naicker]

Assuming D4 = Oranges and E4 = a
H4=INDEX($B$1:$B$1000,MATCH(D4,A$1:A$1000,0)+MATCH(E4,OFFSET($A$1,MATCH(D4,A$1:A$1000,0),0,10000,1),0),1)

and if D4 = Oranges and D5 = a?

 

[Naicker]

Also why is the index set for column B?

 

[PCL]

and if D4 = Oranges and D5 = a
no D4 is for fruit selection and E4 is for a, b, c etc...!
assuming data in column A and B