2007 wont be a date, unless yo tell it, its a date (via the format menu).

When you use the cell ref, are you getting any kind of an answer? or a #value?

I've just tried what you have, and it works fine, bit of a strange one really.


"Don" wrote:

is it because the 2007 is a date? try and copy / past special to another
cell for each of these and make sure the format and data are the same. That
is what I had an issue with before.

"GEORGE HUMPHRIES" wrote:

Can anyone help me please.

I have a problem with the criteria part of sumif using cell values.

I can type a value into a criteria directly in for example 2007, and it
works.

e.g. SUMIF(YEAR,2007,VALUE)

Where year and value are ranges.

But when I refer to a cell such as B12 which contains the value 2007, the
criteria doesn't work.

SUMIF(YEAR,B12,VALUE)

Does the cell reference need to be MARKED in any way?

George Humphries