Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - sumif not updating properly | Excel Discussion (Misc queries) | |||
Updating an inception-to-date formula | Excel Discussion (Misc queries) | |||
date updating | Excel Worksheet Functions | |||
Sumif referring to range names formulas not updating | Excel Worksheet Functions | |||
updating date! | Excel Worksheet Functions |