OFFSET dynamic range

[Apaka]

Hi. I don't know how to approach this so am seeking help. In column H of the attached sample file, I am trying to compute the percentage in column G with an amount in column D, but only for rows in column F that have "IT"; in column I, I am trying to compute the percentage in column G with an amount in column E.

Column F checks (COUNTIF) if a row is on a list (column S), and column G then applies a percentage found in column T (INDEX MATCH). With that I would be able to use a SUMIFS in columns O and P to sum an organization.

Not all of the rows will get summarized. For example, rows 14 and 15 will not meet the criteria and therefore not get summed. D2 has 75% of the amount showing on H3; E3 has 75% of the amount showing in I3. A dynamic example is D28, which will show 100% of the amount showing on H30, and 100% of E30 showing on I30.

All of the cells in YELLOW highlight in column C are to show examples of what would be on the list in column S.

I hope this isn't too confusing as I know it is sometimes difficult to explain via text.

I appreciate any help.