calcualte the avarage every 9 cell

[AmandaSS]

Hallo everybody,

I have a row with 9 (different) variables repeating 365 times. I have to calculate the avarage of each variable, over 365 times.

the example is for an hypotetical case of a row with 3 different variables repeating 365 times.
I have
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A1
[/TD]
[TD]B1
[/TD]
[TD]C1
[/TD]
[TD]D1
[/TD]
[TD]E1
[/TD]
[TD]F1
[/TD]
[TD]G1
[/TD]
[TD]H1
[/TD]
[TD]I1
[/TD]
[TD]L1
[/TD]
[TD]M1
[/TD]
[TD]N1
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]prod
[/TD]
[TD]level[/TD]
[TD]price[/TD]
[TD]prod[/TD]
[TD]level[/TD]
[TD]price
[/TD]
[TD]prod[/TD]
[TD]level
[/TD]
[TD]price
[/TD]
[TD]avarage prod
[/TD]
[TD]avarage level
[/TD]
[TD]avarage price
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]p1
[/TD]
[TD]l1[/TD]
[TD]pr1
[/TD]
[TD]...
[/TD]
[TD]...
[/TD]
[TD]...
[/TD]
[TD]p365
[/TD]
[TD]l365
[/TD]
[TD]pr 365
[/TD]
[TD]avarage(price1, ..., price365)
[/TD]
[TD]avarage(level1, ..., level365)
[/TD]
[TD]avarage(pr1, ..., pr365)
[/TD]
[/TR]
</tbody>[/TABLE]

I hope it's clear enough.
Thanks a lot as usual

Amanda

 

[AmandaSS]

If you are unable to adapt the solution, designed for a sample you posted, to your real data, you should perhaps reconsider posting another more convenient sample directly on the board, which is representative of your data.

Yes, ok. I hope I make myself understand.
A:G is what I have, H:N is what I want. I will have to repeat the logic in H:N also for ROSN and no-cong in the following 2 sets of 5 cells.
Thanks,
Amanda

[TABLE="width: 696"]
<tbody>[TR]
[TD="class: xl75, width: 116"][/TD]
[TD="class: xl75, width: 116"]A[/TD]
[TD="class: xl75, width: 116"]B[/TD]
[TD="class: xl75, width: 116"]C[/TD]
[TD="class: xl75, width: 116"]D[/TD]
[TD="class: xl75, width: 116"]E[/TD]
[TD="class: xl75, width: 116"]F[/TD]
[TD="class: xl75, width: 116"]G[/TD]
[TD="class: xl75, width: 116"](H)
SICI[/TD]
[TD="class: xl75, width: 116"](I)
SICI[/TD]
[TD="class: xl75, width: 116"](L)
SICI[/TD]
[TD="class: xl75, width: 116"](M) SICI[/TD]
[TD="class: xl75, width: 116"](N)
SICI[/TD]
[/TR]
[TR]
[TD="class: xl75, width: 116"]1[/TD]
[TD="class: xl75, width: 116"]hours of the day[/TD]
[TD="class: xl75, width: 116"]SICI[/TD]
[TD="class: xl75, width: 116"]ROSN[/TD]
[TD="class: xl75, width: 116"]no congestion
[/TD]
[TD="class: xl75, width: 116"]SICI[/TD]
[TD="class: xl75, width: 116"]ROSN[/TD]
[TD="class: xl75, width: 116"]no congestion
[/TD]
[TD="class: xl75, width: 116"]Ccgt[/TD]
[TD="class: xl75, width: 116"]Olio[/TD]
[TD="class: xl75, width: 116"]Tg[/TD]
[TD="class: xl75, width: 116"]Fer[/TD]
[TD="class: xl75, width: 116"]no congestion
[/TD]
[/TR]
[TR]
[TD="class: xl74"]2[/TD]
[TD="class: xl74"]1[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]COUNT "Ccgt" in B2,E2[/TD]
[TD="class: xl74"]COUNT "Oil" in B2,E2[/TD]
[TD="class: xl74"]COUNT "Tg" in B2,E2[/TD]
[TD="class: xl74"]COUNT "Fer" in B2,E2[/TD]
[TD="class: xl74"]COUNT "no congestion" in B2,E2
[/TD]
[/TR]
[TR]
[TD="class: xl74"]3[/TD]
[TD="class: xl74"]2[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
[TR]
[TD="class: xl74"]4[/TD]
[TD="class: xl74"]3[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]2[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[/TR]
[TR]
[TD="class: xl74"]5[/TD]
[TD="class: xl74"]4[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
[TR]
[TD="class: xl74"]6[/TD]
[TD="class: xl74"]5[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
[TR]
[TD="class: xl74"]7[/TD]
[TD="class: xl74"]6[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
[TR]
[TD="class: xl74"]8[/TD]
[TD="class: xl74"]7[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
[TR]
[TD="class: xl74"]9[/TD]
[TD="class: xl74"]8[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
[TR]
[TD="class: xl74"]10[/TD]
[TD="class: xl74"]9[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
[TR]
[TD="class: xl74"]11[/TD]
[TD="class: xl74"]10[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]no congestion[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]no congestion[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
[TR]
[TD="class: xl74"]12[/TD]
[TD="class: xl74"]11[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]no congestion[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
[TR]
[TD="class: xl74"]13[/TD]
[TD="class: xl74"]12[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
[TR]
[TD="class: xl74"]14[/TD]
[TD="class: xl74"]13[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
[TR]
[TD="class: xl74"]15[/TD]
[TD="class: xl74"]14[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
[TR]
[TD="class: xl74"]16[/TD]
[TD="class: xl74"]15[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]no congestion[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
[TR]
[TD="class: xl74"]17[/TD]
[TD="class: xl74"]16[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Fer[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
[TR]
[TD="class: xl74"]18[/TD]
[TD="class: xl74"]17[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
[TR]
[TD="class: xl74"]19[/TD]
[TD="class: xl74"]18[/TD]
[TD="class: xl74"]Olio[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Olio[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
[TR]
[TD="class: xl74"]20[/TD]
[TD="class: xl74"]19[/TD]
[TD="class: xl74"]Olio[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Olio[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
[TR]
[TD="class: xl74"]21[/TD]
[TD="class: xl74"]20[/TD]
[TD="class: xl74"]Tg[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Tg[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]2[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[/TR]
[TR]
[TD="class: xl74"]22[/TD]
[TD="class: xl74"]21[/TD]
[TD="class: xl74"]Fer[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Olio[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]1[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]1[/TD]
[TD="class: xl74"]0[/TD]
[/TR]
[TR]
[TD="class: xl74"]23[/TD]
[TD="class: xl74"]22[/TD]
[TD="class: xl74"]Olio[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Olio[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]2[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[/TR]
[TR]
[TD="class: xl74"]24[/TD]
[TD="class: xl74"]23[/TD]
[TD="class: xl74"]Olio[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Olio[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
[TR]
[TD="class: xl74"]25[/TD]
[TD="class: xl74"]24[/TD]
[TD="class: xl74"]Ccgt[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]Olio[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[TD="class: xl74"][/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Yes, ok. I hope I make myself understand.
A:G is what I have, H:N is what I want. I will have to repeat the logic in H:N also for ROSN and no-cong in the following 2 sets of 5 cells.
Thanks,
Amanda
...

H1 shows Ccgt if I understand the posted exhibit. If so:

H2, copied down:

=COUNTIF(B2:E2,$H$1)

Is this what you are after?

 

[AmandaSS]

H1 shows Ccgt if I understand the posted exhibit. If so:

H2, copied down:

=COUNTIF(B2:E2,$H$1)

Is this what you are after?

thanks, but this formula doesnt really work.

In H2 I want to count how many times I have Ccgt in correspondence with SICI.
In I2 I want to count how many times I have Olio in correspondance with SICI. And so on for Tg Fer and no-congestion (in correspondence with SICI).

Btw, I was considering to re-organise my data set in a way that it's easier to get the result I am looking for. And avoid to formulate too complicated calculation.
Thanks

 

[Aladin Akyurek]

thanks, but this formula doesnt really work.

In H2 I want to count how many times I have Ccgt in correspondence with SICI.
In I2 I want to count how many times I have Olio in correspondance with SICI. And so on for Tg Fer and no-congestion (in correspondence with SICI).

Btw, I was considering to re-organise my data set in a way that it's easier to get the result I am looking for. And avoid to formulate too complicated calculation.
Thanks

When you post a sample, try to post one that shows what a suggested formula has to consider, along with the expected counts. The current sample has two ccgt's in B2:E2 and that's what the suggested formula calculates. SICI doesn't affect this calculation... I don't see why you dismissed an earlier suggestion which used the SICI condition explicitly.

 

[AmandaSS]

yes, it's true I am back to this code here
=SUM(IF(ISNUMBER(SEARCH(E$1,$A$2:$D$2)),IF($A3:$D3=E$2,1)))

which has a reference to SICI.

Otherwise I will simplify the data set and then implement formulas. this is also a smart approach
thanks !
</pre>

</pre>

 

[AmandaSS]

Hi All,

I am back to this treat because I need something similar to the previous formulas,

I have a row of heading (2 headings repeated a number of times) and columns of figures.
I need to calculate how many times "text" appears for each heading.

[TABLE="width: 500"]
<tbody>[TR]
[TD]what I have
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]what I want
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD](A1) Heading 1
[/TD]
[TD](B1) heading 2
[/TD]
[TD](C1) heading 1
[/TD]
[TD](D1) heading 2
[/TD]
[TD]....
[/TD]
[TD]text1
[/TD]
[TD]text2
[/TD]
[TD]text3
[/TD]
[TD]text4
[/TD]
[/TR]
[TR]
[TD]text 1
[/TD]
[TD]text3
[/TD]
[TD]text3
[/TD]
[TD]text4
[/TD]
[TD][/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]text4
[/TD]
[TD]text3
[/TD]
[TD]text4
[/TD]
[TD]text4
[/TD]
[TD][/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]text2
[/TD]
[TD]text1
[/TD]
[TD]text2
[/TD]
[TD]text4
[/TD]
[TD][/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]text1
[/TD]
[TD]text2
[/TD]
[TD]text1
[/TD]
[TD]text4
[/TD]
[TD][/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks
Amanda

 

[Aladin Akyurek]

Let K:N house what you want with K1:N1 listing text1, text2, etc.

K2, copied across and down

=COUNTIF($A2:$D2,K$1)

 

[AmandaSS]

[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD]what I have
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]what I want
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]heading 1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]heading 2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD](A1) Heading 1[/TD]
[TD](B1) heading 2[/TD]
[TD](C1) heading 1[/TD]
[TD](D1) heading 2[/TD]
[TD][/TD]
[TD]text1[/TD]
[TD]text2[/TD]
[TD]text3[/TD]
[TD]text4
[/TD]
[TD][/TD]
[TD]text1
[/TD]
[TD]text2
[/TD]
[TD]text3
[/TD]
[TD]text4
[/TD]
[/TR]
[TR]
[TD]text 1
[/TD]
[TD]text3[/TD]
[TD]text3[/TD]
[TD]text4[/TD]
[TD][/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD][/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]text4[/TD]
[TD]text3[/TD]
[TD]text4[/TD]
[TD]text4[/TD]
[TD][/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]text2[/TD]
[TD]text1[/TD]
[TD]text2[/TD]
[TD]text4[/TD]
[TD][/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD][/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]text1[/TD]
[TD]text2[/TD]
[TD]text1[/TD]
[TD]text4[/TD]
[TD][/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD][/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hi Aladin,

what I wrote above is actually what I needed. Sorry I was not enough accurate in my explanation.
Amanda

 

[Aladin Akyurek]

[...]
Hi Aladin,

what I wrote above is actually what I needed. Sorry I was not enough accurate in my explanation.
Amanda

Rearranging lay-out would allow you to run...

F4, copied across and down:

=COUNTIFS($A$3:$D$3,F$2,$A4:$D4,F$3)

See: https://dl.dropboxusercontent.com/u/65698317/AmandaSS%20countifs.xlsx