Counting Various Things

  • Thread starter Thread starter robzrob
  • Start date Start date
R

robzrob

I've got 6 worksheets (one for each workstation) in a workbook all
with various data (user who made entry, date entered, entered am/pm,
week entered, entry type, month entered, etc.) How can I set up
worksheet 7 so that I can count different things - eg number of
entries made by user A in the afternoons, number of entries of type B
made by user C at workstation D in April, total number of entries at
workstation E, etc, etc. I've tried a pivot table but can't get on
with it.
 
Hi,

It would help to share the workbook in which you have this information. You
may mail the workbook to me at (e-mail address removed).
 

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

How do I find like data in multiple worksheets? 1
Count cells based upon criteria in other cells 13
count no. of times a character occurs in a cell 2
count month when date is in day/month/year format 6
Product by Month formula 5
Adding up total hours worked on employee schedule using various criteria 0
Counting cell entries 4
complex sort search and replace macro 2

Back
Top