• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Counting Total number of persons for name card printing

VDS

Member
Dear All respected members,

I received an excel data from one of the Korean Companies named "HYOSUNG CORPORATION" (as attached), which is required for Badge Printing.

There are so many companies in the same format with much more data. Here, counting of names manually will become slightly difficult.

Is there any way to count total number of persons for "HYOSUNG CORPORATION" with formula. Here the result is 40.


The main point here is The columns are not merged. The Blank row can not be deleted due to setting in the printer.


Is the net result can be achieved any formula ? help is requested.


Please accept my apologies if it is illogical.


VDS
 

Attachments

  • Data.xlsx
    19.6 KB · Views: 0
Hi VDS,
I think you simply need to count the companies:
=COUNTIF(F7:F166,F9)+COUNTIF(B7:B166,B9)

Regards,
 
Back
Top