zoom38

02-22-2006, 12:10 AM

Im trying to use the countif function to count the number of cells with "A" or "A*".My formula looks like this: COUNTIF(C7:C20,"A") + COUNTIF(C7:C20,"A*).

The problem here is that when I use "A*" in the formula. It doubles the result. Ex. if "A" is in 4 cells the result is 8. Interestingly if I hit the = sign next to the formula window(not sure what its called) it displays:

COUNTIF

Range C$7:C$20 = {0;"A";0;"A";0;0;"B".

Criteria "A*" = "A*"

= 4

Formula Result = 8

Why does it take the correct answer 4 and multiply by 2 to get the formula result of 8? Same thing occurs with other results. 5 Formula Resut = 10, 3 Formula Result = 6 etc.

Now if I have "A*" in one of the range cells and "A" in three others I get:

COUNTIF

Range C$7:C$20 = {0;"A";0;"A";0;0;"B".

Criteria "A*" = "A*"

= 4

Formula Result = 7

Anyone out there know why this is happening?

Thanks

Gary

The problem here is that when I use "A*" in the formula. It doubles the result. Ex. if "A" is in 4 cells the result is 8. Interestingly if I hit the = sign next to the formula window(not sure what its called) it displays:

COUNTIF

Range C$7:C$20 = {0;"A";0;"A";0;0;"B".

Criteria "A*" = "A*"

= 4

Formula Result = 8

Why does it take the correct answer 4 and multiply by 2 to get the formula result of 8? Same thing occurs with other results. 5 Formula Resut = 10, 3 Formula Result = 6 etc.

Now if I have "A*" in one of the range cells and "A" in three others I get:

COUNTIF

Range C$7:C$20 = {0;"A";0;"A";0;0;"B".

Criteria "A*" = "A*"

= 4

Formula Result = 7

Anyone out there know why this is happening?

Thanks

Gary