Using >CELL in SUMIF Criteria

[N. Thole]

Where one range (B25:M25) is years and the other is $
amounts (B27:M27), I am attempting to set the criteria so
that it will only count particular years. This works:

=SUMIF($B$25:$M$25,">2003",B27:M27)

But I would like to change ">2003" instead to a particular
cell (in this case ">B7"), so that the criteria can be
changed and updated automotically.

Is there a way to do this in SUMIF or do I need to use SUM
(IF)? If the latter is the case, how?

 

[Aladin Akyurek]

=SUMIF($B$25:$M$25,">"&B7,$B$27:$M$27)

 

[Peo Sjoblom]

Try

=SUMIF($B$25:$M$25,">"&B7,B27:M27)

 

[Leo Heuser]

Excel "sees" ">B7" as a string with 3 characters
< B and 7.
To make Excel see B7 as a reference use
">" & B7
instead

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

 

[N. Thole]

Thanks to all three for your solution. For one reason or
another, I had not run into that before.