Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - sumif not updating properly [email protected] Excel Discussion (Misc queries) 2 June 2nd 08 10:23 PM
Updating an inception-to-date formula Eric Excel Discussion (Misc queries) 0 April 16th 08 01:14 PM
date updating Katie Excel Worksheet Functions 1 August 17th 07 11:48 PM
Sumif referring to range names formulas not updating Excel_Still_Stumps_ME Excel Worksheet Functions 1 September 19th 06 08:14 PM
updating date! via135 Excel Worksheet Functions 3 February 23rd 06 05:31 PM


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

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"