Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What type formula to use?
Hi,
I need a formula that takes into account todays date before it adds the row range. The spreadsheet I'm working with has 2 tabs. On the second tab are the rows I need added: B2:AL2 For this to show what is needed I need it to only display a number through the current date. So using the current date the 9th - I won't want to add the rest of the month. Is this possible? If not what formula can I use that only adds within the row and displays the amount added once something is inputted into the row? Sorry if this is a little strange. Thank you for your help :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Type of SUM formula ??? | Excel Discussion (Misc queries) | |||
Cannot see formula descriptions in worksheet as I type a formula. | Excel Worksheet Functions | |||
Look for a certain type of formula... | Excel Discussion (Misc queries) | |||
Just need to know what type of formula i would use for this | Excel Worksheet Functions | |||
"IF" type formula | Excel Discussion (Misc queries) |