The first thing you are doing wrong is not telling us what formula you are
using.
The second thing you are doing wrong is not telling us what you mean by "not
working". What were the data values, what result did you get, and what
result did you expect?
Unfortunately we're not very good at guessing.
--
David Biddulph

sjmdhd wrote:
I have two worksheet, and I want to do a Sumif() function in sheet 1
but the data is in sheet 2, I had no problem using this function in
excel 2003, however; it's not working in excel 2007, what I'm I doing
wrong?