Counting (Countifs) in excel2003
 

Hi,

I need to count with two parameters, but I can't get it to work in excel 2003.
I'm using Excel 2007 and the CountIFS command, and that is working, but when
I want to save the file as 97-2003 it pops up with Error on the formular.

What is this formular in excel 2003 language?

=CountIfs(June!A7:A200,"JP",June!J7:J200,"*")

the * is not a wildecard but I'm sorting by using the * symbol.

Hope to hear from you soon,

Michael

Counting (Countifs) in excel2003
 

Hi

=COUNTIF(June!A7:A200,"JP",June!J7:J200)



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Samutprakarn" wrote in message
...
Hi,

I need to count with two parameters, but I can't get it to work in excel
2003.
I'm using Excel 2007 and the CountIFS command, and that is working, but
when
I want to save the file as 97-2003 it pops up with Error on the formular.

What is this formular in excel 2003 language?

=CountIfs(June!A7:A200,"JP",June!J7:J200,"*")

the * is not a wildecard but I'm sorting by using the * symbol.

Hope to hear from you soon,

Michael

Counting (Countifs) in excel2003
 

Hi,

I just tried this one, but it doesn't work. It says there are too many
arguments in the statement.

I think I didn't make the problem clear hehe

I'm using the Countifs to find how many times "JP" and the "*" is present in
the same row of the sheet, and how in the heck do I do the same in Excel2003?

Michael

"Arvi Laanemets" wrote:

Hi

=COUNTIF(June!A7:A200,"JP",June!J7:J200)



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Samutprakarn" wrote in message
...
Hi,

I need to count with two parameters, but I can't get it to work in excel
2003.
I'm using Excel 2007 and the CountIFS command, and that is working, but
when
I want to save the file as 97-2003 it pops up with Error on the formular.

What is this formular in excel 2003 language?

=CountIfs(June!A7:A200,"JP",June!J7:J200,"*")

the * is not a wildecard but I'm sorting by using the * symbol.

Hope to hear from you soon,

Michael

Counting (Countifs) in excel2003
 

I'm using the Countifs to find how many times "JP" and
the "*" is present in the same row of the sheet
the * is not a wildecard

On the same row *but* in different cells or in the *same* cell?

By the looks of your COUNTIFS formula you want to count if the range
contains JP or "*" .

Try one of these:

To count cells with the string JP* (asterisk, not the wildcard)

=COUNTIF(A7:A15,"JP~*")

To count cells that contain either JP or * (asterisk, not the wildcard)

=COUNTIF(A7:A15,"JP")+COUNTIF(A7:A15,"~*")

Or

=SUM(COUNTIF(A7:A15,{"JP","~*"}))

Biff

"Samutprakarn" wrote in message
...
Hi,

I just tried this one, but it doesn't work. It says there are too many
arguments in the statement.

I think I didn't make the problem clear hehe

I'm using the Countifs to find how many times "JP" and the "*" is present
in
the same row of the sheet, and how in the heck do I do the same in
Excel2003?

Michael

"Arvi Laanemets" wrote:

Hi

=COUNTIF(June!A7:A200,"JP",June!J7:J200)



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Samutprakarn" wrote in message
...
Hi,

I need to count with two parameters, but I can't get it to work in
excel
2003.
I'm using Excel 2007 and the CountIFS command, and that is working, but
when
I want to save the file as 97-2003 it pops up with Error on the
formular.

What is this formular in excel 2003 language?

=CountIfs(June!A7:A200,"JP",June!J7:J200,"*")

the * is not a wildecard but I'm sorting by using the * symbol.

Hope to hear from you soon,

Michael

Counting (Countifs) in excel2003
 

JP is in one Cell and * is in another cell :)

I want to count how many times JP and * appears in the same row (the
horizontal way) the "JP" Value is located in A and the "*" is located in J.

Sorry for my bad explanation, it's my first time with Excel :(

Michael

"T. Valko" wrote:

I'm using the Countifs to find how many times "JP" and
the "*" is present in the same row of the sheet
the * is not a wildecard

On the same row *but* in different cells or in the *same* cell?

By the looks of your COUNTIFS formula you want to count if the range
contains JP or "*" .

Try one of these:

To count cells with the string JP* (asterisk, not the wildcard)

=COUNTIF(A7:A15,"JP~*")

To count cells that contain either JP or * (asterisk, not the wildcard)

=COUNTIF(A7:A15,"JP")+COUNTIF(A7:A15,"~*")

Or

=SUM(COUNTIF(A7:A15,{"JP","~*"}))

Biff

"Samutprakarn" wrote in message
...
Hi,

I just tried this one, but it doesn't work. It says there are too many
arguments in the statement.

I think I didn't make the problem clear hehe

I'm using the Countifs to find how many times "JP" and the "*" is present
in
the same row of the sheet, and how in the heck do I do the same in
Excel2003?

Michael

"Arvi Laanemets" wrote:

Hi

=COUNTIF(June!A7:A200,"JP",June!J7:J200)



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Samutprakarn" wrote in message
...
Hi,

I need to count with two parameters, but I can't get it to work in
excel
2003.
I'm using Excel 2007 and the CountIFS command, and that is working, but
when
I want to save the file as 97-2003 it pops up with Error on the
formular.

What is this formular in excel 2003 language?

=CountIfs(June!A7:A200,"JP",June!J7:J200,"*")

the * is not a wildecard but I'm sorting by using the * symbol.

Hope to hear from you soon,

Michael

Counting (Countifs) in excel2003
 

Try this:

=SUMPRODUCT(--(A7:A15="JP"),--(J7:J15="*"))

Biff

"Samutprakarn" wrote in message
...
JP is in one Cell and * is in another cell :)

I want to count how many times JP and * appears in the same row (the
horizontal way) the "JP" Value is located in A and the "*" is located in
J.

Sorry for my bad explanation, it's my first time with Excel :(

Michael

"T. Valko" wrote:

I'm using the Countifs to find how many times "JP" and
the "*" is present in the same row of the sheet
the * is not a wildecard

On the same row *but* in different cells or in the *same* cell?

By the looks of your COUNTIFS formula you want to count if the range
contains JP or "*" .

Try one of these:

To count cells with the string JP* (asterisk, not the wildcard)

=COUNTIF(A7:A15,"JP~*")

To count cells that contain either JP or * (asterisk, not the wildcard)

=COUNTIF(A7:A15,"JP")+COUNTIF(A7:A15,"~*")

Or

=SUM(COUNTIF(A7:A15,{"JP","~*"}))

Biff

"Samutprakarn" wrote in message
...
Hi,

I just tried this one, but it doesn't work. It says there are too many
arguments in the statement.

I think I didn't make the problem clear hehe

I'm using the Countifs to find how many times "JP" and the "*" is
present
in
the same row of the sheet, and how in the heck do I do the same in
Excel2003?

Michael

"Arvi Laanemets" wrote:

Hi

=COUNTIF(June!A7:A200,"JP",June!J7:J200)



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Samutprakarn" wrote in
message
...
Hi,

I need to count with two parameters, but I can't get it to work in
excel
2003.
I'm using Excel 2007 and the CountIFS command, and that is working,
but
when
I want to save the file as 97-2003 it pops up with Error on the
formular.

What is this formular in excel 2003 language?

=CountIfs(June!A7:A200,"JP",June!J7:J200,"*")

the * is not a wildecard but I'm sorting by using the * symbol.

Hope to hear from you soon,

Michael

Counting (Countifs) in excel2003
 

YES!!! THANK YOU THANK YOU!!!!

Now it's working :) you just made my day T. Valko thank you very much :)

Michael

"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(A7:A15="JP"),--(J7:J15="*"))

Biff

"Samutprakarn" wrote in message
...
JP is in one Cell and * is in another cell :)

I want to count how many times JP and * appears in the same row (the
horizontal way) the "JP" Value is located in A and the "*" is located in
J.

Sorry for my bad explanation, it's my first time with Excel :(

Michael

"T. Valko" wrote:

I'm using the Countifs to find how many times "JP" and
the "*" is present in the same row of the sheet
the * is not a wildecard

On the same row *but* in different cells or in the *same* cell?

By the looks of your COUNTIFS formula you want to count if the range
contains JP or "*" .

Try one of these:

To count cells with the string JP* (asterisk, not the wildcard)

=COUNTIF(A7:A15,"JP~*")

To count cells that contain either JP or * (asterisk, not the wildcard)

=COUNTIF(A7:A15,"JP")+COUNTIF(A7:A15,"~*")

Or

=SUM(COUNTIF(A7:A15,{"JP","~*"}))

Biff

"Samutprakarn" wrote in message
...
Hi,

I just tried this one, but it doesn't work. It says there are too many
arguments in the statement.

I think I didn't make the problem clear hehe

I'm using the Countifs to find how many times "JP" and the "*" is
present
in
the same row of the sheet, and how in the heck do I do the same in
Excel2003?

Michael

"Arvi Laanemets" wrote:

Hi

=COUNTIF(June!A7:A200,"JP",June!J7:J200)



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Samutprakarn" wrote in
message
...
Hi,

I need to count with two parameters, but I can't get it to work in
excel
2003.
I'm using Excel 2007 and the CountIFS command, and that is working,
but
when
I want to save the file as 97-2003 it pops up with Error on the
formular.

What is this formular in excel 2003 language?

=CountIfs(June!A7:A200,"JP",June!J7:J200,"*")

the * is not a wildecard but I'm sorting by using the * symbol.

Hope to hear from you soon,

Michael

Counting (Countifs) in excel2003
 

You're welcome. Thanks for the feedback!

Biff

"Samutprakarn" wrote in message
...
YES!!! THANK YOU THANK YOU!!!!

Now it's working :) you just made my day T. Valko thank you very much :)

Michael

"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(A7:A15="JP"),--(J7:J15="*"))

Biff

"Samutprakarn" wrote in message
...
JP is in one Cell and * is in another cell :)

I want to count how many times JP and * appears in the same row (the
horizontal way) the "JP" Value is located in A and the "*" is located
in
J.

Sorry for my bad explanation, it's my first time with Excel :(

Michael

"T. Valko" wrote:

I'm using the Countifs to find how many times "JP" and
the "*" is present in the same row of the sheet
the * is not a wildecard

On the same row *but* in different cells or in the *same* cell?

By the looks of your COUNTIFS formula you want to count if the range
contains JP or "*" .

Try one of these:

To count cells with the string JP* (asterisk, not the wildcard)

=COUNTIF(A7:A15,"JP~*")

To count cells that contain either JP or * (asterisk, not the
wildcard)

=COUNTIF(A7:A15,"JP")+COUNTIF(A7:A15,"~*")

Or

=SUM(COUNTIF(A7:A15,{"JP","~*"}))

Biff

"Samutprakarn" wrote in
message
...
Hi,

I just tried this one, but it doesn't work. It says there are too
many
arguments in the statement.

I think I didn't make the problem clear hehe

I'm using the Countifs to find how many times "JP" and the "*" is
present
in
the same row of the sheet, and how in the heck do I do the same in
Excel2003?

Michael

"Arvi Laanemets" wrote:

Hi

=COUNTIF(June!A7:A200,"JP",June!J7:J200)



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Samutprakarn" wrote in
message
...
Hi,

I need to count with two parameters, but I can't get it to work
in
excel
2003.
I'm using Excel 2007 and the CountIFS command, and that is
working,
but
when
I want to save the file as 97-2003 it pops up with Error on the
formular.

What is this formular in excel 2003 language?

=CountIfs(June!A7:A200,"JP",June!J7:J200,"*")

the * is not a wildecard but I'm sorting by using the * symbol.

Hope to hear from you soon,

Michael