Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL 2003 HELP
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, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL 2003 HELP
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. "Sandy Mann" wrote: 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! -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "ROBERT" wrote in message ... 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, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL 2003 HELP
You're very welcome and I agree, this site is a blessing.
-- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "ROBERT" wrote in message ... 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. "Sandy Mann" wrote: 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! -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "ROBERT" wrote in message ... 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unable to paste Excel 2003 chart into Outlook 2003 | Charts and Charting in Excel | |||
opening excel files from access 2003, win xp, office 2003 | Excel Discussion (Misc queries) | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |