Re: How to solve the program with SUMIF function

[Jody Goldberg <jody gnome org>]

On Tue, May 28, 2002 at 02:59:09PM -0400, Zupnik, Susan wrote:
> The way you described the function below, still doesn't work ....
>
> I mean....  When I want to use the cell reference i.e.    Cell 12:
> 5/20/2002
>
> And I want to use the sumif as follows:    (need to use  'greater than'  in
> criteria)
>
>       sumif (E3:E9, "=" > C12, F3:F9 )
>
> Whereas   E3:  5/10/2002       F3:  100
>            E4:  5/12/2002       F4:  100
>            E5:  5/14/2002       F5:  200
>            E6:  5/19/2002       F6:  100
>            E7:  5/22/2002       F7:  300
>            E8:  5/24/2002       F8:  200
>            E9:  5/27/2002       F9:  100
>
> The answer  should be:   600
>
> I'm getting the answer:  0  !

try this
        sumif (E3:E9, ">" & C12, F3:F9 )