SUMIF Function

[Johnny]

I'm trying to reference a cell for the criteria value but have been only able
to enter an actual value. For example I would like to use the following:

=SUMIF($J:$J,<A1,K:K)

where A1 is cell I'm trying to reference which happens to be a date value.
I've trying using paranthesis but it doesn't work. It only works for me when
I type in the actual value. The cell value changes frequently and I'm trying
to find a way to avoid have to change the value in the formula each time that
happens. Any help would be appreciated.

[Vito]

Try:

=SUMIF($J:$J,"<"&A1,K:K)

[Marcelo]

Hi Johnny,

try this

=SUMIF($J:$J,"<A1",K:K)

HTH
Regards from Brazil
Marcelo

"Johnny" escreveu:

> I'm trying to reference a cell for the criteria value but have been only able
> to enter an actual value. For example I would like to use the following:
>
> =SUMIF($J:$J,<A1,K:K)
>
> where A1 is cell I'm trying to reference which happens to be a date value.
> I've trying using paranthesis but it doesn't work. It only works for me when
> I type in the actual value. The cell value changes frequently and I'm trying
> to find a way to avoid have to change the value in the formula each time that
> happens. Any help would be appreciated.

[Johnny]

That worked. Much thanks!!!

"Vito" wrote:

>
> Try:
>
> =SUMIF($J:$J,"<"&A1,K:K)
>
>
> --
> Vito
> ------------------------------------------------------------------------
> Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
> View this thread: http://www.excelforum.com/showthread...hreadid=553747
>
>