CSE problems

Posted by Graham Johnson on June 27, 2001 5:35 AM

I have two column arrays, each containing integers.

I want to count, for example, how many times the number 3 occurs in array 1 opposite number 5 in array 2.

I have tried using a [countif(if] CSE formula, which is "accepted" but only returns VALUE?

thanks in advance,
Graham

Posted by AB on June 27, 2001 5:50 AM

{=SUM((A1:A10=3)*(B1:B10=5))}

Regards,
AaronThe Excel Logic Page

Posted by Graham Johnson on June 27, 2001 8:27 AM

Re: {=SUM((A1:A10=3)*(B1:B10=5))}

Thanks, but...

I tried this but it isn't accepted - the message being "Array formulas are not valid in merged cells"
Graham

Posted by Aladin Akyurek on June 27, 2001 8:35 AM

Re: {=SUM((A1:A10=3)*(B1:B10=5))}

Just unmerge the cell. You can then merge afterwards. However, it's better to leave those cells alone to avoid problems later.

Aladin