I use Excel 2007

I have a table of about 50 columns and 60 rows.
Each row must be compared with the first row of the table:
Is there a formula, that counts the number of cells in each row that has an
identical value with the corresponding cell in the header?

Piet,

Is this what you mean

=COUNTIF(B2:AX2,A2)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Piet" wrote:

> I use Excel 2007
>
> I have a table of about 50 columns and 60 rows.
> Each row must be compared with the first row of the table:
> Is there a formula, that counts the number of cells in each row that has an
> identical value with the corresponding cell in the header?

For each row

=SUMPRODUCT(--(A2:AX2<>""),--(A2:AX2=$A$1:$AX$1))

and copy dwn

--

HTH

Bob

"Piet" <(E-Mail Removed)> wrote in message
newsF24AE12-6458-4BA1-8711-(E-Mail Removed)...
>I use Excel 2007
>
> I have a table of about 50 columns and 60 rows.
> Each row must be compared with the first row of the table:
> Is there a formula, that counts the number of cells in each row that has
> an
> identical value with the corresponding cell in the header?

Assume that you are having the header value in A1 cell and you want to count
and compare it with the 2nd Row from A2 to AX2 then use the below formula.

=COUNTIF(A2:AX2,A1)

You can also protect the cell number by adding an $ (Dollar) symbol like the
below.
=COUNTIF(A$2:AX$2,A$1)

Use the above formula other than A1 cell and A2 to AX2 range.

--
Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Piet" wrote:

> I use Excel 2007
>
> I have a table of about 50 columns and 60 rows.
> Each row must be compared with the first row of the table:
> Is there a formula, that counts the number of cells in each row that has an
> identical value with the corresponding cell in the header?

Bob,

thanks for your answer, which helps me a lot.
I have to study the function a while as I don't understand the solution, but
it works nevertheless fantastic!.

Thanks again.

Regards,
Piet

"Bob Phillips" wrote:

> For each row
>
> =SUMPRODUCT(--(A2:AX2<>""),--(A2:AX2=$A$1:$AX$1))
>
> and copy dwn
>
> --
>
> HTH
>
> Bob
>
> "Piet" <(E-Mail Removed)> wrote in message
> newsF24AE12-6458-4BA1-8711-(E-Mail Removed)...
> >I use Excel 2007
> >
> > I have a table of about 50 columns and 60 rows.
> > Each row must be compared with the first row of the table:
> > Is there a formula, that counts the number of cells in each row that has
> > an
> > identical value with the corresponding cell in the header?
>
>
> .
>

Mike,

Thanks for your attemt. But it was not were I was looking for. Bob Philips
gave me the solution.
Thanks for your effort in this.
Regards,
Piet


"Mike H" wrote:

> Piet,
>
> Is this what you mean
>
> =COUNTIF(B2:AX2,A2)
> --
> Mike
>
> When competing hypotheses are otherwise equal, adopt the hypothesis that
> introduces the fewest assumptions while still sufficiently answering the
> question.
>
>
> "Piet" wrote:
>
> > I use Excel 2007
> >
> > I have a table of about 50 columns and 60 rows.
> > Each row must be compared with the first row of the table:
> > Is there a formula, that counts the number of cells in each row that has an
> > identical value with the corresponding cell in the header?

Thanks for your attemt. But it was not were I was looking for. Bob Philips
gave me the solution.
Thanks for your effort in this.
Regards,
Piet


"Ms-Exl-Learner" wrote:

> Assume that you are having the header value in A1 cell and you want to count
> and compare it with the 2nd Row from A2 to AX2 then use the below formula.
>
> =COUNTIF(A2:AX2,A1)
>
> You can also protect the cell number by adding an $ (Dollar) symbol like the
> below.
> =COUNTIF(A$2:AX$2,A$1)
>
> Use the above formula other than A1 cell and A2 to AX2 range.
>
> --
> Remember to Click Yes, if this post helps!
>
> --------------------
> (Ms-Exl-Learner)
> --------------------
>
>
> "Piet" wrote:
>
> > I use Excel 2007
> >
> > I have a table of about 50 columns and 60 rows.
> > Each row must be compared with the first row of the table:
> > Is there a formula, that counts the number of cells in each row that has an
> > identical value with the corresponding cell in the header?

This may help you http://xldynamic.com/source/xld.SUMPRODUCT.html

--

HTH

Bob

"Piet" <(E-Mail Removed)> wrote in message
news:97ABA64F-2E01-4DD8-A2A0-(E-Mail Removed)...
> Bob,
>
> thanks for your answer, which helps me a lot.
> I have to study the function a while as I don't understand the solution,
> but
> it works nevertheless fantastic!.
>
> Thanks again.
>
> Regards,
> Piet
>
> "Bob Phillips" wrote:
>
>> For each row
>>
>> =SUMPRODUCT(--(A2:AX2<>""),--(A2:AX2=$A$1:$AX$1))
>>
>> and copy dwn
>>
>> --
>>
>> HTH
>>
>> Bob
>>
>> "Piet" <(E-Mail Removed)> wrote in message
>> newsF24AE12-6458-4BA1-8711-(E-Mail Removed)...
>> >I use Excel 2007
>> >
>> > I have a table of about 50 columns and 60 rows.
>> > Each row must be compared with the first row of the table:
>> > Is there a formula, that counts the number of cells in each row that
>> > has
>> > an
>> > identical value with the corresponding cell in the header?
>>
>>
>> .
>>