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

[Guest]

I hoping that you can help me. Below you will find an example of a spreadsheet that I'm trying to to perform a sumif formula with dates. In the constant row I use the formula of =SUMIF($B$7:$B$11,">12/12/2002",$C$7:$C$11) and receive the value of 1,695.00. In the variable row I use the formula of =SUMIF($B$7:$B$11,">c3",$C$7:$C$11). I'm trying to acutally use the row of dates instead of having to put in the actual date each time but when I use the field of C3 for the date it returns the value of 0.

A B C D E F G

2
3 12/12/20021/15/2003 2/5/2003 2/28/2003 3/19/2003 6/16/00
4 constant 1,695.00 1,495.00 1,495.00 1,195.00 645.00 0.0
5 variable 0.00 0.00 0.00 0.00 0.00 0.0
6 Months
7 1/2/2003 $200.00
8 2/10/2003 $300.00
9 3/15/2003 $550.00
10 4/18/2003 $450.00
11 5/5/2003 $195.00

Thanks in advance


When using a variable the result is a zero

 

[Frank Kabel]

Hi Sherry
try
=SUMIF($B$7:$B$11,">" & c3,$C$7:$C$11)

HTH
Frank