HI Tsony
I'm not the expert,David would be the guy to answer that better then me.
But my conclusion is because "=" is inclosed in brackets excel need to
have this symbal &, it's like saying bigger or equal and A20.
Maybe someone will give you a better answer.
For you to know when i build a formula i go to InsertFunction and with the
Function Argument menu and can see if it's good and can modify it on that
menu.
HTH
John
"tsony" wrote in message
...
Thanks John.

I got the answer when I put the & symbol before the cell ref. Do you know
why we put the & symbol?

--
tsony


"John" wrote:

Try this : =SUMIF(C2:G2,"="&A20,C5:G5)
HTH
John
"tsony" wrote in message
...
There is small correction in the question the range is from c2 to k2
and
c5
to k5
--
tsony


"tsony" wrote:

Hi

I have a row c2: c25 which contains date row c5:c25 contains amounts.
I
need
to add the amounts when I select a date from the section box at
a20(the
date
is selected from the c2:c25 date validation list). The result will be
on
the
row c27. I tried the formula =sumif(c5:c25, "=a20", c2:c25) but it
adds
all
the amounts ignoring the critera =a20. Is there any easy way to do
this?
Some times it shows zero.
--
tsony