| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 COUNTIFS | Excel Discussion (Misc queries) | |||
| excel's new countifs...on 2003? | Excel Discussion (Misc queries) | |||
| Countifs and multiple columns... | Excel Worksheet Functions | |||
| Multiple countifs | Excel Worksheet Functions | |||
| COUNTIFs with multiple criteria | Excel Discussion (Misc queries) | |||
Hybrid Mode
