Count No of Engagements

O

ogerriz

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
 
J

Jacob Skaria

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

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

If this post helps click Yes
 
T

Teethless mama

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count of Engagements by Salesperson 1
Data Lookup Question 1
Count Numeric Value with condition 5
COUNT 1
Pivot tables - counting unique numbers 2
Counting number of items excluding duplicates. 1
Count of Non-Zero pivot table entries 1
Count unique values 5

Top