Thread
:
SUMIF , CAN I USE THIS FORMULA BUT WITHOUT UPDATING THE DATE?
View Single Post
#
3
Posted to microsoft.public.excel.misc
Fred Smith[_4_]
external usenet poster
Posts: 2,389
SUMIF , CAN I USE THIS FORMULA BUT WITHOUT UPDATING THE DATE?
Use the following syntax instead:
=sumif(a1:a20,"="&c1,b1:b20)
or
=sumif(a1:a20,"="&today(),b1:b20)
Regards,
Fred.
"WAHEEB AKEEL" <WAHEEB
wrote in message
...
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
Reply With Quote
Fred Smith[_4_]
View Public Profile
Find all posts by Fred Smith[_4_]