Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a month as a trigger to do a calculation
I have a spreadsheet that has entries set out by date. I now need to break
that data out by month so it can be totaled. Have tried a couple of solutions and am not finding something that really gets me what I need. Basically what I need to do is: If cell E1 is a date in June I need to total the dollars in columns E4-E7. If the month is not June then I do not need it to do anything. Would need to to the same for each month of year in different columns. Currentlyl I am doing this manually and looking for a better solution that eliminates the manual input. Any ideas would be welcome. -- debra |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a month as a trigger to do a calculation
=IF(MONTH(E1)=6,SUM(E4:E7),"")
See if that doesn't help. "debra" wrote: I have a spreadsheet that has entries set out by date. I now need to break that data out by month so it can be totaled. Have tried a couple of solutions and am not finding something that really gets me what I need. Basically what I need to do is: If cell E1 is a date in June I need to total the dollars in columns E4-E7. If the month is not June then I do not need it to do anything. Would need to to the same for each month of year in different columns. Currentlyl I am doing this manually and looking for a better solution that eliminates the manual input. Any ideas would be welcome. -- debra |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a month as a trigger to do a calculation
Hello debra, at the most basic level you can use a formula like
=IF(MONTH(E1)=6,SUM(E4:E7),"") Does that help? Note: this won't differentiate by year "debra" wrote: I have a spreadsheet that has entries set out by date. I now need to break that data out by month so it can be totaled. Have tried a couple of solutions and am not finding something that really gets me what I need. Basically what I need to do is: If cell E1 is a date in June I need to total the dollars in columns E4-E7. If the month is not June then I do not need it to do anything. Would need to to the same for each month of year in different columns. Currentlyl I am doing this manually and looking for a better solution that eliminates the manual input. Any ideas would be welcome. -- debra |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a month as a trigger to do a calculation
I use Excel 2003
The month() function will return the number of the month of a date, from 1-12. You can use this in combination with a lookup function to retrieve the month name from a list if you need / want the name 1 January 2 February 3 March .... To do the summation, you might look into the subtotals command in conjunction with the above. "debra" wrote: I have a spreadsheet that has entries set out by date. I now need to break that data out by month so it can be totaled. Have tried a couple of solutions and am not finding something that really gets me what I need. Basically what I need to do is: If cell E1 is a date in June I need to total the dollars in columns E4-E7. If the month is not June then I do not need it to do anything. Would need to to the same for each month of year in different columns. Currentlyl I am doing this manually and looking for a better solution that eliminates the manual input. Any ideas would be welcome. -- debra |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add text in a cell to trigger a calculation | Excel Worksheet Functions | |||
Last Day Of Month Calculation... | Excel Worksheet Functions | |||
Month end calculation | Excel Worksheet Functions | |||
MOREFUNC.XLL - RECALL() to trigger once only calculation? | Excel Discussion (Misc queries) | |||
month-to-month calculation | Excel Discussion (Misc queries) |