Using Months in Excel
Posted by Johnnie on September 11, 2001 9:29 AM
Hi, Can somebody please help me!!
I need to show details for a given month only. For example:
If the month is September then I need to show the amount of data within the September column only. I am trying to use Today() as this needs to be updated automatically. Any ideas would be greatfully appreciated. Cheers ;o)
E.g.
Aug/Sep/Oct Monthly Total
2 3 0 3
1 0 0 0
0 4 0 4
Posted by IML on September 11, 2001 10:46 AM
Try:
=SUM((MONTH($A$1:$C$1)=MONTH(NOW()))*(A2:C2))
and copying down. You must hit enter while control and shift are depressed. Also, A1:C1 must be date formats.
Posted by Johnnie on September 11, 2001 11:17 AM
Thnx for the reply IML. Would it be possible for me to email you my spreadsheet? which I will detail fully and see if you can see my dilema. I am new at spreadsheets and would appreciate any help possible :) again thnx for replying
Posted by IML on September 11, 2001 1:04 PM
Unfortunately, I can't receive files. To clarify a little further, I assumed your dates were in A1:C1. You could type in a date like 9/1/01 and format it to mmmm so "september" would appear
The formula I gave you would be typed under your monthly total column (D2) in my example. Then you could simple copy D2 down as far as you need.
Sorry I couldn't help more.
Posted by Aladin Akyurek on September 11, 2001 1:11 PM
Ian & Johnnie,
Even after Ian's interpretation, it's not clear to me what is wanted.
Maybe Johnnie can post 5 rows of data (from his worksheet) with the expected results.
Aladin
============ Unfortunately, I can't receive files. To clarify a little further, I assumed your dates were in A1:C1. You could type in a date like 9/1/01 and format it to mmmm so "september" would appear
Posted by johnnie on September 12, 2001 4:42 AM
Thnx for all your help so far. I have uploaded my spreadsheet to my homepage if you would'nt mind taking a look for me. Pict takes a while to download. it's at:
(link no longer valid)
Once again I appreciate your help :) Ian & Johnnie, Even after Ian's interpretation, it's not clear to me what is wanted. Maybe Johnnie can post 5 rows of data (from his worksheet) with the expected results. Aladin ============ : Unfortunately, I can't receive files. To clarify a little further, I assumed your dates were in A1:C1. You could type in a date like 9/1/01 and format it to mmmm so "september" would appear
Posted by Aladin Akyurek on September 12, 2001 5:34 AM
Johnnie,
In S7 enter: =INDEX(C7:Q7,MATCH(TEXT(TODAY(),"mmm"),$C$4:$Q$4,0))
Copy down this formula as far as needed.
Aladin
============= Thnx for all your help so far. I have uploaded my spreadsheet to my homepage if you would'nt mind taking a look for me. Pict takes a while to download. it's at: Once again I appreciate your help :) : Ian & Johnnie, : Even after Ian's interpretation, it's not clear to me what is wanted. : Maybe Johnnie can post 5 rows of data (from his worksheet) with the expected results. : Aladin : ============
Posted by Johnnie on September 12, 2001 5:56 AM
Niceone m8 Worked a treat. I am forever in your debt. THANK YOU VERY MUCH!!! :D Johnnie, In S7 enter: =INDEX(C7:Q7,MATCH(TEXT(TODAY(),"mmm"),$C$4:$Q$4,0)) Copy down this formula as far as needed. Aladin ============= : Thnx for all your help so far. I have uploaded my spreadsheet to my homepage if you would'nt mind taking a look for me. Pict takes a while to download. it's at
