Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / September 2007

Tip: Looking for answers? Try searching our database.

EXCEL 2003 HELP

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ROBERT - 17 Sep 2007 11:08 GMT
I NEED TO KNOW IF THIS IS POSSIBLE.

I WANT SOME CELLS TO HAVE A CERTAIN DOLLAR AMOUNT VALUE TO EACH CELL. THIS
SHOULD NOT BE DISPLAYED IN THE CELL.

I WANT THOSE SAME CELLS TO DISPLAY DATES AS I ENTER THEM WHEN THE DATES PASS.

I WANT A SEPARATE CELL TO SUM THE DOLLAR AMOUT FROM THOSE CELLS WITHOUT
BEING AFFECTED BY THE DATES I HAVE ENTERED.

IN OTHER WORDS, I WANT THE CELL TO DISPLAY ONE THING, BUT MEAN SOMETHING
ELSE. IN ADDITION, I DON'T WANT THE CELL TO BE ADDED I THE DESIGNATED "SUM
CELL", SO TO SPEAK, UNTIL I ENTER THE DATE IN THAT CELL.

IS THIS AT ALL POSSIBLE? OR AM I THINKING WAY TOO HARD?

THANKS,
Sandy Mann - 17 Sep 2007 11:18 GMT
A cell cannot hold both a dollar amount and a date, (although both are just
numbers), at the same time.
Enter the dollar amounts in an adjacent cell then add then up with the
formula:

=SUMIF(C17:C29,"<="&TODAY(),D17:D29)

where the dates are in C17:C29 and the dollar amounts are in D17:D29

Please do not post in block capitals some people, especially those whose
first language is not English find it hard to read and it is considered
SHOUTING!

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

>I NEED TO KNOW IF THIS IS POSSIBLE.
>
[quoted text clipped - 14 lines]
>
> THANKS,
ROBERT - 20 Sep 2007 06:20 GMT
Sandy Mann,

Thank you for your post. The formula was exactly what I needed. This site is
a blessing. I'm sure I'll use it again...

Thank you,
Robert

P.S.
Thank you for the insight on using capital letters in a post. I was not
aware of the issue. I hope I did not offend you or anyone else. If I did, I
apolagize.

> A cell cannot hold both a dollar amount and a date, (although both are just
> numbers), at the same time.
[quoted text clipped - 27 lines]
> >
> > THANKS,
Sandy Mann - 20 Sep 2007 11:44 GMT
You're very welcome and I agree, this site is a blessing.

Signature

Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> Sandy Mann,
>
[quoted text clipped - 46 lines]
>> >
>> > THANKS,
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.