#1   Report Post  
Old February 11th 05, 04:05 PM
Carpie
 
Posts: n/a
Default Cumulative Summing

I am successfully doing cumulative summing for columns Jan-05 thru Dec-05
based on cell I1 which puts today's date into text by =TEXT(TODAY(),"mmm-yy").

I then use the formula =SUM($O3:INDEX($O3:$Z3,MATCH($I$1,$O$2:$Z$2,0)))
which compares today's date in text vs what I have manually inputted for
month headings in text.

Everything works fine as long as everyone uses an English copy of Excel.
This is not the case in our France location however so when they open up the
spreadsheet, today's date in text is showing as Févr-05 which of course does
not match the English headings of Feb-05. I could of course input the month
headings in text in French so it would match, but then it would not work when
someone with an English copy opens up the spreadsheet.

So I either need a solution to this translation issue, or a new way to do
cumulative summing where I don't need to change dates into text. Any help
would be immensely appreciated.

  #2   Report Post  
Old February 11th 05, 04:13 PM
Springbok
 
Posts: n/a
Default

Hi,

How about adjusting the column headings to be, for instance for Jan 04
=TEXT(DATE(2004,01,01),"mmm-yy")?

Cheers,
Jon

"Carpie" wrote:

I am successfully doing cumulative summing for columns Jan-05 thru Dec-05
based on cell I1 which puts today's date into text by =TEXT(TODAY(),"mmm-yy").

I then use the formula =SUM($O3:INDEX($O3:$Z3,MATCH($I$1,$O$2:$Z$2,0)))
which compares today's date in text vs what I have manually inputted for
month headings in text.

Everything works fine as long as everyone uses an English copy of Excel.
This is not the case in our France location however so when they open up the
spreadsheet, today's date in text is showing as Févr-05 which of course does
not match the English headings of Feb-05. I could of course input the month
headings in text in French so it would match, but then it would not work when
someone with an English copy opens up the spreadsheet.

So I either need a solution to this translation issue, or a new way to do
cumulative summing where I don't need to change dates into text. Any help
would be immensely appreciated.

  #3   Report Post  
Old February 11th 05, 04:14 PM
Peo Sjoblom
 
Posts: n/a
Default

Use formulas for your headers as well

=TEXT(DATE(2005,2,1),"mmm-yy")

(for February as an example)

then your headers will be translated as well


--

Regards,

Peo Sjoblom

"Carpie" wrote in message
...
I am successfully doing cumulative summing for columns Jan-05 thru Dec-05
based on cell I1 which puts today's date into text by

=TEXT(TODAY(),"mmm-yy").

I then use the formula =SUM($O3:INDEX($O3:$Z3,MATCH($I$1,$O$2:$Z$2,0)))
which compares today's date in text vs what I have manually inputted for
month headings in text.

Everything works fine as long as everyone uses an English copy of Excel.
This is not the case in our France location however so when they open up

the
spreadsheet, today's date in text is showing as Fvr-05 which of course

does
not match the English headings of Feb-05. I could of course input the

month
headings in text in French so it would match, but then it would not work

when
someone with an English copy opens up the spreadsheet.

So I either need a solution to this translation issue, or a new way to do
cumulative summing where I don't need to change dates into text. Any help
would be immensely appreciated.



  #4   Report Post  
Old February 11th 05, 04:35 PM
Carpie
 
Posts: n/a
Default


Eureka! You two are the best. Sometimes the simple answer is always the
one overlooked.

"Peo Sjoblom" wrote:

Use formulas for your headers as well

=TEXT(DATE(2005,2,1),"mmm-yy")

(for February as an example)

then your headers will be translated as well


--

Regards,

Peo Sjoblom

"Carpie" wrote in message
...
I am successfully doing cumulative summing for columns Jan-05 thru Dec-05
based on cell I1 which puts today's date into text by

=TEXT(TODAY(),"mmm-yy").

I then use the formula =SUM($O3:INDEX($O3:$Z3,MATCH($I$1,$O$2:$Z$2,0)))
which compares today's date in text vs what I have manually inputted for
month headings in text.

Everything works fine as long as everyone uses an English copy of Excel.
This is not the case in our France location however so when they open up

the
spreadsheet, today's date in text is showing as Févr-05 which of course

does
not match the English headings of Feb-05. I could of course input the

month
headings in text in French so it would match, but then it would not work

when
someone with an English copy opens up the spreadsheet.

So I either need a solution to this translation issue, or a new way to do
cumulative summing where I don't need to change dates into text. Any help
would be immensely appreciated.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summing Time JDT Excel Discussion (Misc queries) 8 February 8th 05 10:53 PM
Cumulative Frequency Chris Grant Charts and Charting in Excel 2 February 3rd 05 05:49 AM
How to make cumulative totals appear on a graph Arlen Excel Discussion (Misc queries) 1 January 17th 05 08:59 PM
Cumulative Total RockyMountains Excel Discussion (Misc queries) 9 January 12th 05 11:03 AM
Summing Sheets - SUMIF ? Steve W Excel Worksheet Functions 8 December 20th 04 06:49 AM


All times are GMT +1. The time now is 06:33 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017