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