View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default SUMIF , CAN I USE THIS FORMULA BUT WITHOUT UPDATING THE DATE?

hi
i think your are having trouble with the cell reference. I think C:1 should
be just C1.
see your other post.

regards
FSt1

"WAHEEB AKEEL" wrote:

MY FURMULA IS
=SUMIF(A1:A20,"=30-AUG",(B1:B20)) .THE PROBLIM IS THAT I HAVE TO CHANGE THE
DATE EVERY DAYS .WHEN I TRY TO INSERT C:1 ,=NOW(),INSTEAD OF 30-AUG" IT SHOW
WRONG.=SUMIF(A1:A20,"=C:1",(B1:B20))
C:1 IS A FORMULA =NOW()
EVERY DAY I HAVE TO UPDATE THE DATE OF ALL MY FORMULAS .
I WILL HIGHLY APPRECIATE IF I GET THE PROPER SULOSION FOR THIS PROBLEM AND
TO BE SENT CC TO MY HOTMAIL BOX "
THANKS
WAHEEB