trying to automate a calculation

[scthread]

I have a column of values i want to add if the value in another column is less than or equal to a number identified in cell b1 which can change.

I can sort of do it using the following:

=SUMIFS(C4:C15,A4:A15,"<=5")

but I want where it says "5" in "<=5" to point to B1's value

when i click on B1 while creating the formula to reference it the formula stops calculating.

Please help.

 

[Eric W]

Try:

=SUMIFS(C4:C15,A4:A15,"<="&B1)

 

[scthread]

Perfect! You are my Excel Hero for the day!

 

[Eric W]

Glad it works for you!

Have a good weekend!