Remember Me?

#1
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 1
SUMIF , CAN I USE THIS FORMULA BUT WITHOUT UPDATING THE DATE?

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
#2
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 3,942
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.

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

#3
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 2,389
SUMIF , CAN I USE THIS FORMULA BUT WITHOUT UPDATING THE DATE?

=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

#4
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 8,651
SUMIF , CAN I USE THIS FORMULA BUT WITHOUT UPDATING THE DATE?

A point of netiquette:
Your caps lock key is broken. Please get it repaired so that you can stop
SHOUTING.
--
David Biddulph

"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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post [email protected] Excel Discussion (Misc queries) 2 June 2nd 08 10:23 PM Eric Excel Discussion (Misc queries) 0 April 16th 08 01:14 PM Katie Excel Worksheet Functions 1 August 17th 07 11:48 PM Excel_Still_Stumps_ME Excel Worksheet Functions 1 September 19th 06 08:14 PM via135 Excel Worksheet Functions 3 February 23rd 06 05:31 PM

All times are GMT +1. The time now is 02:11 AM.