Count No of Engagements
 

I have a table that 1240 rows and 300 columns. The main column field that we
use to summarise the data via pivot tables is the engagement column. The
eng# is unique however it can appear in that column more than once because
there are services within that engagement and that is also in the table.

How can I count the number of engagements but not the number of entries in
the table (if I say count then it gives me 1240 obviously).

A sample will be:

Eng # EMID Service #
12A 1 57477
12A 1 57485
12A 1 60000
13A 50 57486
14A 5 57999

so if i ask for the count of engagements the result I want to get is 3.

Thanks

Count No of Engagements
 

The below formula should give you the number of engagements...

=SUMPRODUCT((A2:A1240<"")/COUNTIF(A2:A1240,A2:A1240&""))

If this post helps click Yes
---------------
Jacob Skaria


"ogerriz" wrote:

I have a table that 1240 rows and 300 columns. The main column field that we
use to summarise the data via pivot tables is the engagement column. The
eng# is unique however it can appear in that column more than once because
there are services within that engagement and that is also in the table.

How can I count the number of engagements but not the number of entries in
the table (if I say count then it gives me 1240 obviously).

A sample will be:

Eng # EMID Service #
12A 1 57477
12A 1 57485
12A 1 60000
13A 50 57486
14A 5 57999

so if i ask for the count of engagements the result I want to get is 3.

Thanks

Count No of Engagements
 

If you have no blank cells in your data. The formula can be simplified

=SUMPRODUCT(1/COUNTIF(A2:A6,A2:A6))


"ogerriz" wrote:

I have a table that 1240 rows and 300 columns. The main column field that we
use to summarise the data via pivot tables is the engagement column. The
eng# is unique however it can appear in that column more than once because
there are services within that engagement and that is also in the table.

How can I count the number of engagements but not the number of entries in
the table (if I say count then it gives me 1240 obviously).

A sample will be:

Eng # EMID Service #
12A 1 57477
12A 1 57485
12A 1 60000
13A 50 57486
14A 5 57999

so if i ask for the count of engagements the result I want to get is 3.

Thanks