Adding up a column based on Criteria

**halvy52** · 07-27-2007, 02:37 PM

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.

**Bryan Hessey** · 07-27-2007, 05:56 PM

Originally Posted by halvy52

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.

Hi,

try

=SUMIF(H13:H50,100%,I13:I50)

hth
---