I'd suggest entering 4/1/05 (1-Apr-05) in A6, that is, the first day
date of the month/year of interest and invoke:

=SUMPRODUCT(--(DATE(YEAR(Data!$S$2:$S$1415),MONTH(Data!$S$2:$S$1 415),1)=A6),--(Data!$T$2:$T$1415="C"))

which would be immediately readable in French.

A. Toczko wrote:
This is the formula I am using:

=SUMPRODUCT(--(Data!$S$2:$S$1415=A6),--(Data!$T$2:$T$1415="C"))
where A6 contains the month name April.

When on the French pc, column S contains various month names, which appear
in French, so when it compares it against A6, which is in English, there is
never a match. On the English pc, all works well of course.

Column S takes the month from another column, showing the month as format
MMMM. Is there a way to lock MMMM into showing English? That would solve
the problem.

Alison

"Peo Sjoblom" wrote in message
...

A workaround would be to use month names derived from formulas as opposed
to hard coded month names. Can you five an example of a formula and the
month it is referring to

--
Regards,

Peo Sjoblom


"A. Toczko" wrote in message
...

I have programmed a worksheet in English, which is being used by someone
who has set his keyboard to French on his pc. The problem here is that I
have formulas which use month names, and on his pc the months show in
French, so the formulas no longer work. When he sends the sheet to me, it
shows in English, and all is well. How do I get around this? Thanks.