SUMIF , CAN I USE THIS FORMULA BUT WITHOUT UPDATING THE DATE?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WAHEEB AKEEL - 30 Aug 2008 17:20 GMT

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 "W-AKEEL@HOTMAIL.COM"
THANKS
WAHEEB

Reply to this Message

FSt1 - 30 Aug 2008 18:21 GMT

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

> MY FURMULA IS
> =SUMIF(A1:A20,">=30-AUG",(B1:B20)) .THE PROBLIM IS THAT I HAVE TO CHANGE THE
[quoted text clipped - 6 lines]
> THANKS
> WAHEEB

Reply to this Message

Fred Smith - 30 Aug 2008 23:21 GMT

Use the following syntax instead:

=sumif(a1:a20,">="&c1,b1:b20)
or
=sumif(a1:a20,">="&today(),b1:b20)

Regards,
Fred.

> MY FURMULA IS
> =SUMIF(A1:A20,">=30-AUG",(B1:B20)) .THE PROBLIM IS THAT I HAVE TO CHANGE
[quoted text clipped - 8 lines]
> THANKS
> WAHEEB

Reply to this Message

David Biddulph - 31 Aug 2008 09:20 GMT

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

> MY FURMULA IS
> =SUMIF(A1:A20,">=30-AUG",(B1:B20)) .THE PROBLIM IS THAT I HAVE TO CHANGE
[quoted text clipped - 8 lines]
> THANKS
> WAHEEB

Reply to this Message