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()

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

"WAHEEB AKEEL" wrote:


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()

Try this:

C1: =NOW()

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

--
Biff
Microsoft Excel MVP


"WAHEEB AKEEL" wrote in message
...

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()

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

Hope this helps.

Pete

On Aug 30, 6:02*pm, WAHEEB AKEEL
wrote:
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()