Sumif Criteria reference problem ?

[amhedley]

Have an excel problem here you might be able to help with. Thank you in advance.

Sumif problem
=SUMIF(range, criteria,(sum_range))
The formulae works if the cell reference is written eg. =SUMIF(A8:A23,"<2006",C8:C23) but
not if cell referenced =SUMIF A8:A23,"<B8",C8:C23) any ideas how to solve this problem?

A / B / C
Range / Criteria /Sum_range
1 / 2006 /0.8
2 2007 1.0
3 2008 0.7
4 2009 1.0
5 2010 0.8
6 2011 0.4
7 2012 0.1
8 2013 0.2
9 2014 0.6
10 2015 0.5
11 2016 0.2
12 2017 0.7
13 2018 0.0
14 2019 0.6
15 2020 0.4
16 2021 0.7

 

[Richard Schollar]

Not sure how you are writing that (the html was turned on which can cause probs) but the following should be OK:

=SUMIF(A8:A23,"<" &$A$1,C8:C23)

 

[amhedley]

Richard Thank you kindly.