ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   SUMIF , CAN I USE THIS FORMULA BUT WITHOUT UPDATING THE DATE? (https://www.excelbanter.com/excel-discussion-misc-queries/200814-sumif-can-i-use-formula-but-without-updating-date.html)

WAHEEB AKEEL

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

FSt1

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


Fred Smith[_4_]

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



David Biddulph[_2_]

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