Counting

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

I have a spreadsheet with a number of columns (Product,
Stage, Campaign, Batch, Page, Operation, Operator, Detail
and Category).

The spreadsheet is used to record errors on documents.

For a particular Product, Stage and Campaign, there may be
10 batches, and each is entered into the spreadsheet.
Then for example, on batch 2, there may be 2 different
categories of error, so this would get two entries in the
spreadsheet.

The more entries for a particular batch, the more errors.
If a batch has no errors, I complete the first 5 columns,
then leave the rest blank.

I need a formula (or formulae) to count up how many
batches had errors on them and how many did not for a
particular Type, Product, Stage and Campaign, so that I
can show the % that had no error on and the % that did.

I hope that this makes sense to someone because I really
can't think how to do this.
 
I don't really understand how you decide whether there were errors, but if you create a column
that indicates that, you can probably get the statistics you need from a pivot table.
 
Back
Top