SumIf formula. If the Value is > or equal to

[gheyman]

I have a table where I have the cost of each item in column AC (AC5:AC60). In the next column I have percentages (each rows percentage of the total value or the sum of column AC)

I want to do a SumIf. My condition is if the % value in column AD is less than or equal to 80%.

I keep getting errors with my formulas. Help! lol

Thanks

 

[Eric W]

Try:

=SUMIF(AD5:AD60,"<=80%",AC5:AC60)

 

[Norie]

What have you tried?

I would have expected something like this would work.

=SUMIF(AD5:AD60, "<=" & 0.08, AC5:AC60)

 

[gheyman]

=SUMIF(AD5:AD60, <= 0.08, AC5:AC60)

Thank you both!