This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
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 individu... See more
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. ▲ Collapse
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.
Translate faster & easier, using a sophisticated CAT tool built by a translator / developer.
Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools.
Download and start using CafeTran Espresso -- for free