| 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 :) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What type formula to use?
Hi,
Why don't you show us a sample of your data layout and what you want. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "CE" wrote: 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 :) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What type formula to use?
Sorry.
On sheet 2 I have column a set up with names. B through AL have dates. 1 2 3 4 5 6 7 8 9 10 etc. John Smith 8 8 8 8 The 8's represent the amount of time off taken. On sheet 1 I have it set up similar. June Taken Total John Smith 40 Under the Taken column is where I need the formula that adds the amount of time off taken from the first of the month through the current date. Sorry if my first post was a little too vague. Please let me know if you need more info. to help me. Thank you, CE "Shane Devenshire" wrote: Hi, Why don't you show us a sample of your data layout and what you want. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "CE" wrote: 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 :) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What type formula to use?
This should be COL B to AF ; right
Try the below formula in AG =SUM(INDIRECT("B" & ROW() & ":" & ADDRESS(ROW(),DAY(TODAY())+1))) If this post helps click Yes --------------- Jacob Skaria "CE" wrote: 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 :) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What type formula to use?
Try this:
=SUM(Sheet2!B2:INDEX(Sheet2!B2:AF2,DAY(NOW()))) -- Biff Microsoft Excel MVP "CE" wrote in message ... Sorry. On sheet 2 I have column a set up with names. B through AL have dates. 1 2 3 4 5 6 7 8 9 10 etc. John Smith 8 8 8 8 The 8's represent the amount of time off taken. On sheet 1 I have it set up similar. June Taken Total John Smith 40 Under the Taken column is where I need the formula that adds the amount of time off taken from the first of the month through the current date. Sorry if my first post was a little too vague. Please let me know if you need more info. to help me. Thank you, CE "Shane Devenshire" wrote: Hi, Why don't you show us a sample of your data layout and what you want. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "CE" wrote: 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 :) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What type formula to use?
THANK YOU!!!
"T. Valko" wrote: Try this: =SUM(Sheet2!B2:INDEX(Sheet2!B2:AF2,DAY(NOW()))) -- Biff Microsoft Excel MVP "CE" wrote in message ... Sorry. On sheet 2 I have column a set up with names. B through AL have dates. 1 2 3 4 5 6 7 8 9 10 etc. John Smith 8 8 8 8 The 8's represent the amount of time off taken. On sheet 1 I have it set up similar. June Taken Total John Smith 40 Under the Taken column is where I need the formula that adds the amount of time off taken from the first of the month through the current date. Sorry if my first post was a little too vague. Please let me know if you need more info. to help me. Thank you, CE "Shane Devenshire" wrote: Hi, Why don't you show us a sample of your data layout and what you want. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "CE" wrote: 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 :) |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What type formula to use?
You're welcome!
-- Biff Microsoft Excel MVP "CE" wrote in message ... THANK YOU!!! "T. Valko" wrote: Try this: =SUM(Sheet2!B2:INDEX(Sheet2!B2:AF2,DAY(NOW()))) -- Biff Microsoft Excel MVP "CE" wrote in message ... Sorry. On sheet 2 I have column a set up with names. B through AL have dates. 1 2 3 4 5 6 7 8 9 10 etc. John Smith 8 8 8 8 The 8's represent the amount of time off taken. On sheet 1 I have it set up similar. June Taken Total John Smith 40 Under the Taken column is where I need the formula that adds the amount of time off taken from the first of the month through the current date. Sorry if my first post was a little too vague. Please let me know if you need more info. to help me. Thank you, CE "Shane Devenshire" wrote: Hi, Why don't you show us a sample of your data layout and what you want. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "CE" wrote: 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 :) |
| Reply |
| 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) | |||
Linear Mode
