Can a variable (date) be used in a SUMIF formula?

[Sherry]

1 A B C D E F
2
3
4 12/12/2002 1/15/2003 2/5/2003 2/28/2003
5 constant 1,695.00 1,495.00 1,495.00 1,195.00
6 variable 0.00 0.00 0.00 0.00
7 Months
8 1/2/2003 $200.00
10 2/10/2003 $300.00
11 3/15/2003 $550.00
12 4/18/2003 $450.00
13 5/5/2003 $195.00



When I use the sumif formula with the date I receive a
value of $1,695.00 see the above example (=SUMIF
($B$8:$B$13,">12/12/2002",$C$8:$C$13)).

When I try to use a variable the result is a zero. The
formula that I use is =SUMIF($B$8:$B$13,">c4",$C$8:$C$13)
C4 is where the date field is located.

What I would like to do is not have to put in the date
each time.

Any help that you can give me is grealty appreciated.

 

[Frank Kabel]

Hi
try
=SUMIF($B$8:$B$13,">" & c4,$C$8:$C$13)

 

[Guest]

Frank,

That worked. Thank you so much.

Sherry

-----Original Message-----
Hi
try
=SUMIF($B$8:$B$13,">" & c4,$C$8:$C$13)

--
Regards
Frank Kabel
Frankfurt, Germany

.