CountIf

NBVC

Well-known Member

Joined

Aug 31, 2005

Messages

5,828

• Dec 13, 2005

• #2

Try evaluating your formula with CTRL+SHIFT+ENTER not just ENTER

 

Upvote 0

R

Roses8

Active Member

Joined

Aug 4, 2005

Messages

348

• Dec 13, 2005

• #3

Thanks, but that does not help at all as I still cannot see the problem with the formula.

 

Upvote 0

NBVC

Well-known Member

Joined

Aug 31, 2005

Messages

5,828

• Dec 13, 2005

• #4

I used your formula and after evaluating it with the CSE combo, I got a 2.

Do you see curly brackets surrounding your formula?

 

Upvote 0

R

Roses8

Active Member

Joined

Aug 4, 2005

Messages

348

• Dec 13, 2005

• #5

Hi, I cannot see any curly brackets..

 

Upvote 0

NBVC

Well-known Member

Joined

Aug 31, 2005

Messages

5,828

• Dec 13, 2005

• #6

Activate the cell containing the formula and press F2, you should see the cursor at the end of the formula.

Now press CTRL, SHIFT and ENTER keys at the same time. You should get those brackets appearing and the result should be what you are looking for.

 

Upvote 0

R

Roses8

Active Member

Joined

Aug 4, 2005

Messages

348

• Dec 13, 2005

• #7

Hi, I got a result of 3 but that did not match anything.

I need the formula to look up A2&C1 match in error details sheet then count ..

=COUNTIF('Error Details'!I14:J1715,A2&C1)

Thanks for all your help.

 

Upvote 0

NBVC

Well-known Member

Joined

Aug 31, 2005

Messages

5,828

• Dec 13, 2005

• #8

Maybe then, you want?

=SUMPRODUCT(--(Error Details!I14:I1715=A2),--(Error Details!J14:J1715=C1))

Confirmed with just Enter.

Edit: Forgot the sheet name in the second argument.

 

Upvote 0

R

Roses8

Active Member

Joined

Aug 4, 2005

Messages

348

• Dec 13, 2005

• #9

Thanks you that is exactly what I was looking for, sorry for my bad explanation.

 

Upvote 0

Aladin Akyurek

MrExcel MVP

Joined

Feb 14, 2002

Messages

85,210

• Dec 13, 2005

• #10

NBVC said:

Activate the cell containing the formula and press F2, you should see the cursor at the end of the formula.

Now press CTRL, SHIFT and ENTER keys at the same time. You should get those brackets appearing and the result should be what you are looking for.

Click to expand...

You insisted on:

{=COUNTIF('Error Details'!I14:J1715,A1:C2)}

in 3 successive posts. Do you know now why this suggestion is flawed?

 

Upvote 0