Using >CELL in SUMIF Criteria

  • Thread starter Thread starter N. Thole
  • Start date Start date
N

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?
 
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.
 
Thanks to all three for your solution. For one reason or
another, I had not run into that before.
 
Back
Top