Advice on tracking word counts per subject category in Excel please?
Thread poster: Vivien Green

Vivien Green  Identity Verified
United Kingdom
Member (2013)
French to English
Feb 4, 2015

I'm trying to calculate word counts by subject category and thus need to upgrade my Excel skills. I was wondering if anyone could help me?

In Excel, if I enter the category a particular job falls under (say, "Legal"), in the same row as the job description, reference number and word count, can I then add the word counts for all jobs in this category quite easily and if so how do I do this? I looked this up online and everything I found was telling me to click on each cell individually, but this doesn't seem practical as my document is already quite big and will only get bigger.

Also, if there's cross-over between subject areas and a job fits into more than one category, does anyone know if Excel will include the word count for a particular job in both categories or in neither of them where a cell contains a hybrid entry, for example "Legal/Education"?

I have posted one other similar questions in this category, just to make people aware and to try to avoid confusion. Apologies if I've posted in the wrong section.

Direct link Reply with quote

To report site rules violations or get help, contact a site moderator:

You can also contact site staff by submitting a support request »

Advice on tracking word counts per subject category in Excel please?

Advanced search

PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search