+ Reply to Thread
Results 1 to 2 of 2

counting input errors

  1. #1
    Registered User
    Join Date
    10-01-2006
    Posts
    15

    counting input errors

    Hello,

    I have a summary of all input errors in a spreadsheet summarised in a worksheet. How can I create a new worksheet which displays a summary total count of the errors.

    i.e. the error is "no arrival time input" and this occurred on a Monday.

    I want to count all instances of "no arrival time input" on a Monday and display the result as a count (such as the total "no arrival time input" errors on monday was 12) and so on, for different errors and different days.
    I presume the answer involves counting instances some how, and formatting the results into a new worksheet in a table like structure? Please see attached.

    The two columns A:B hold the error name and the day it occurred.

    I know I can do this with an array? But, I would like to add this to a macro, so the sheet does not exist until I investigate the spreadsheet.


    Please help.

    Matt
    Attached Files Attached Files

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    Here's a formula

    =SUMPRODUCT(--(Errors!$A$2:$A$100=Summary!$C12)*(Errors!$B$2:$B$100=D$11))

    Why don't you just record a simple macro to hide and unhide the sheet. Instead of creating it from scratch each time


    VBA Noob
    Last edited by VBA Noob; 12-09-2006 at 06:38 PM.
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1