Counting (Countifs) in excel2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
Click to expand...

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
 
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
 
YES!!! THANK YOU THANK YOU!!!!

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

Michael
 
You're welcome. Thanks for the feedback!

Biff

Samutprakarn said:
YES!!! THANK YOU THANK YOU!!!!

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

Michael
Click to expand...
 
Back
Top