need help with the COMPANIES software (they're not up to date). I need to count the total number of "n" in column c that correspond to specific numbers (i.e. '48' or '24' ect.) in column b. column b cannot be ORGANIZED, the numbers will occur randomly. I don't have access to any addin WIZARDS either. is this possible to do?Does this help?:

I was actually able to figure out that much (being the dope that I am) but column c contains y and n (yes and no) and I need a total count of the n('s) that correspond to the designated number in column b (same row)


Your LAYOUT still isn't clear to me. You have numbers in col. b. Column c contains y and n (yes and no), so column c is taken, right? Do you want the counts of the number of occurrences of certain values in column b, in column d?I need a count of occurances in column c that correspond to numbers in column b. this count total goes at BOTTOM of c. did I say that right?I sense a bit of an attitude here. The forum is here to provide free help. No body gets paid for taking time to respond to questions. I think I'll not continue this discussion.My bust and most sincere appologies, no attitude intended, I am sorry if it came off that way, it was not intended to. I am in construction, field work mostly, very little computer stuff. I also have a dry sense of humor (according to my wife). Again, I am sorry and did not mean to insult or degrade anyone.Not sure if it's right, but it works:

=sum(if(range=#,if(range="n",1,0))) then control+shift+enter

Is that what they call an array? (serious question).OK, got your PM; no problem re: my previous concerns.

I believe the formula you posted in a nested formula, not an array, although control+shift+enter is used to enter array formulas. I really haven't delved into array formulas. A nested formula is indicated when you have one function embedded in another, such as an IF function within another IF function, as you have done.

Does that formula seem to be working for you?



Works great! does what I needed, but I did have to enter as an array. not sure why, but I do beleive that "if it ain't broke..." I think, not sure, that the array had to be used becuase of the mix of letters and numbers. that or this machine doesn't like me. thanks for the help.