Hopefully somebody can help me with this.... I have 2 columns of data. One is a percentage one is a dollar value. Lets say my data is in H13:H500 for my percentage and I13:I500 for my dollar value. In a separate cell I need to know the combined dollar value of all of the percentages that equal 100% in my H column are. Does this make sense to anybody.

Lets say I want this formula to go into A1. So here's my formula in my own words..... If H13=100% then I13
That's the simplified version doing it with one row.... I want to do this.......

if H13:H50=100% then in A1 add up all of the corresponding I13:I50

am I losing anybody? Thanks.