Help with Array IF-ISERROR-INDEX formula

Hello

I am trying to use a criteria cell to pull specific information from two columns and display them on another worksheet in the same workbook. The information is displayed in rows. I am using a combination formula that pulls only one result and it will not autofil down to display the other two remaining results. If it is possible to pull adjacent data from two columns at once that would be great, otherwise I will repeat the formula to extract the second set of data. I have included a sample workbook with the main worksheet and the desired results sheet. It also includes my formula.
Any help would be greatly appreciated
Thanks
Leaoni

I did it for numbers but couldnt figure out the texts
=INDEX(LARGE(IF((Sheet1!$A$5:$A$9='Results Sheet'!$H$1)*1=1,Sheet1!$C$5:$C$9,""),ROW($1:$3)),ROW(1:1)) CSE

Another way (without the need of CSE):

=IFERROR(SUMPRODUCT((Sheet1!$A$5:$A$9='Results Sheet'!$H$1)*(Sheet1!$B$5:$B$9='Results Sheet'!$H3)*Sheet1!$C$5:$C$9),"")

Place in 'Results Sheet'!I3

Thank you. What I would like to show is a breakdown of what the total amount of the acct 720 is. The amount is $535.00 and I want to show Chevron, Esso, Shell and their corresponding totals below.
I don't need them in largest to smallest or visa versa. Having them show just as they are in the list is fine. I was wanting to take out the SMALL function but did not know what else to remove from the formula. Also, I believe I can use this same formula to have the corresponding text show beside the individual breakdown of the total. I hope I have explained this OK.

Thank you for your help
Leaoni

You have the SUMIF() working on the first sheet which does what you need but if you want the subtotal you can use the same formula I posted but change the third criteria:

=IFERROR(SUMPRODUCT((Sheet1!$A$5:$A$9='Results Sheet'!$H$1)*(Sheet1!$B$5:$B$9='Results Sheet'!$H3)*Sheet1!$E$5:$E$9),"")

None of the formulas put them in order, they just happen to be that way already.

Hello Everyone

Thank you to everyone who assisted me with this formula challenge. My file works like a charm