Check for Number in one column - then count specific numbers in a range.

Guys I would appreciate any help you could offer me on this
(I spent 3 days searching about everyplace I can think of for a solution)

Column "B" has 75 items. Of those items 1 to 25 are numbered the rest are blank.
(All are needed, but only the newest 25 are relative).

Column "D" through "J" have numbers (75 per column).
I need to use the numbers in column "B" Only to "Authorize" searching D1:J75 for the number of occurrences of a specific number.
(The number in "B" is else-wise semi irrelevant)

The Numbers in column "B" will be re-ordered when "New" data is appended to future rows.

I have tried COUNTIF, COUNTIFS, SUMPRODUCT, IF-Then with no luck.
I am new(ish) to the more advanced features of Excel, but I am familiar with the program itself (So its possible that I made a newbie error somewhere).

Thanks - I Really appreciate it...

Thanks -
Here's the idea:

example.xlsx

Hi Carlos

So for the value of 1 in B7, you want to count the instances where the value of 17 (d7) occurs in range D7:D81?

So for the value of 1 in B7, you want to count the instances where the value of 17 (d7) occurs in range D7:D81?

Close, I do want to be able to count the number of times a number repeats/occurs in the range D7:H51
But B7 (the "B" Column) isn't a "Value" - More like an on/off switch - if there is a number there include that row in the search of the range. (And to number the 25 most recent entries)

So........

The criteria is that column B has a value >0 and when this is met, then a calculation is performed.

In your example, for B7 (as 1>0 so criteria met) what's the calculation you want to happen?

I need to use the numbers in column "B" Only to "Authorize" searching D1:J75 for the number of occurrences of a specific number.

What is the specific number (in your example) that you want to count the instances of?

Multitasking badly so apologies if you clearly stated this earlier

YES!!! That's the Key!

I want to see how many times a specific number is in the range D7:J75.
(I'll put the formula adjacent to the number I'm looking for and edit the formula accordingly (I.E. Q + R columns)

Say I'm looking for #1 in the range the formula would go into R7, If Looking for #2 it would go into R8 - etc.

No need to apologize, Multitasking myself.

Also posted at http://www.mrexcel.com/forum/excel-q...ers-range.html

Please see rule #8 http://www.excelforum.com/forum-rule...rum-rules.html and http://www.excelguru.ca/content.php?184

Please see rule #8 http://www.excelforum.com/forum-rule...rum-rules.html

Also posted at http://www.mrexcel.com/forum/excel-q...ers-range.html

Sure Did!

- Good Catch and thanks for linking in the other forum.
(Personally I consider it bad manners to promote another forum on a forums site - but if that's what they want - so be it).

This issue is still unresolved - Still looking for answers!

I'm still not completely clear, from your example, as to which number(s) you are wanting a count of if column B >0.

I have a range (D7:H31 (marked yellow in your example)) and a criteria (>0) however I need the specific number you need a count of to progress...

I want to see how many times a specific number is in the range D7:J75.
(I'll put the formula adjacent to the number I'm looking for and edit the formula accordingly (I.E. Q + R columns)

Say I'm looking for #1 in the range the formula would go into R7, If Looking for #2 it would go into R8 - etc.

1) So as B7 is 1, what number am I needing to count the instances of in your highlighted range?

2) What's the relevance of the range D7:J75 in the example provided as your last highlighted row is 31?

3) Based on your example provided, what's your expected result in R7 and what number was counted to give that result?