Countif(s)?INDEX

[CMLET]

Column A's data value begins with 444 and continues down to 111. Approx. 12000 rows.

A B C
444 0 1
444 1 8
444 3 6
444 2 4
444 1 7
444 3 5
444 1 8
444 1 7
444 2 4
444 1 6
444 1 5
444 3 5
444 3 4
444 2 4
444 1 4
444 3 3
444 1 3
444 4 1
443 3 2
443 2 3
443 -1 4
443 2 3
443 1 2
443 1 2
443 3 2
443 0 2
443 -1 4
443 0 2
443 -1 4
443 2 3
443 -1 4

 

[pecoflyer]

Your question being? We do not have a crystal ball

 

[CMLET]

A formula to count occurrences in column B associated with column A into column C.

 

[GraH - Guido]

CMLET, as per forum rules, please upload a sample file, and make a manual example of what the result should be. Saves us some trouble. Indeed, we are not clairvoyants. Even with the extra info given. What is an occurrence col B associated with col A into col C?
Seems you have already values in C?

Would it be =SUMPRODUCT((A2:$A$32=A2)*(B2:$B$32=B2))?

 

[Fluff13]

Without a file this is a guess, but maybe
=COUNTIFS(A:A,A2,B:B,B2)

 

[CMLET]

Apologies to members. In column A there are 18 rows containing 444. Column B1 the value is 0. "0" occurred once within those 18 rows in Column A containing the value 444. B2 value is 1. "1" occurred eight times within those 18 rows in column A. The sample was manual to illustrate in Column C the results. I will adhere much closely to the rules in the future. Thanks for your consideration.

 

[Fluff13]

Do either of the solutions provided work for you?
If not please explain why not & provide a sample workbook

 

[pecoflyer]

Is it too much to ask to provide a sample sheet with some data and expected results?

 

[CMLET]

The sample sheet shows some data in columns A and B. Column C is Blank. The expected results are illustrated and listed in columns E,F,G. Notice the number 444 in column A. In column B the number 1 totals (8) occurrences, within that group of number, and the number 3 (5) occurrences, etc. etc. I've have tried variations of formulas (i.e. index/match countif(s) sumproduct/if...so on. no luck? That you for your consideration.

 

[Fluff13]

Te formula I supplied works for me, with your data you just need to change the A2 & B2 to A1 & B1

 

[CMLET]

Thank you.

 

[Fluff13]

You're welcome