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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 04:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com