PLEASE HELP

[WAHEEB AKEEL]

MY FORMULA IS
=SUMIF(Y3:Y104,">=27-AUG",R3:R104)-(L106+L107)

HOW CAN I USE UPDATABLE CRITERIA, INSTEAD THE ABOVE , FOR EXAMPLE C:I WHICH
IS =NOW()

 

[FSt1]

hi
not sure if you understand your example but....updateable criteria.......
you could put the date in a cell say Y1 or whatever then edit the formula

=SUMIF(Y3:Y104,">=" & Y1,R3:R104)-(L106+L107)

regards
FSt1

 

[T. Valko]

Try this:

C1: =NOW()

=SUMIF(Y3:Y104,">="&C1,R3:R104)-(L106+L107)

 

[Pete_UK]

I suggest you use TODAY() rather than NOW() if you are only interested
in the date and not the time.

Hope this helps.

Pete