Re: Please help - Looking for a way to sum up for specific error codes

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thank you, however what formula would I use if there were other names
in column A that had the same error code of "soe" during those months?
But I only want to calculate how many "SOE" errors Joe had for that
quarter of business.

Your help is appreciated,
Joe



FSt1 wrote:
=countif(range,criteria)
=countif(A1:D5,"SOE")

regards
FSt1

"Joe" wrote:

Here is an example of what I am trying to capture: Every SOE entry that
Joe during the months of June, July, and August. According to this
example the total is 3.

(A) (B) (C) (D)
REGION NAME MONTH ERROR CODE
EAST JOE JUNE SOE
EAST JOE JULY SOE
EAST JOE AUGUST SOE
West Jane June SOE
North Bob July SOE

Thanks for helping me.



.

Relevant Pages

  • Re: Problem when creating a call with TAPI
    ... Are you sure that TAPI is not supported by VB.NET? ... Joe ... > besides providing an error code please also note that ... > Best regards, ...
    (microsoft.public.win32.programmer.tapi)
  • Re: Adding an Icon To a CPropertySheet
    ... Nevermind Joe, I found it. ... "Joseph M. Newcomer" wrote: ... you have explicitly set the value to "Show no icon". ... Note that ASSERT resets the error code to 0, ...
    (microsoft.public.vc.mfc)
  • Re: Server 2003 shuts down unexpectedly
    ... No charge for hotfixes. ... > "Joe" wrote: ... >>>I work for a support company and one of our customers ... >>>supplied the following error code and I have had no luck ...
    (microsoft.public.windows.server.general)
  • Re: Error with Append Query
    ... Hi Joe ... error code you want to ignore, and do a Resume Next (or whatever else you ... >> Microsoft Office Access can't append all the records in the append query. ... failure, and it didn't add 1 recoordto the table due to key violations, ...
    (microsoft.public.access.formscoding)
  • Re: Exchange NDR
    ... it keeps trying for a specified period which can be set or ... The error code shown here, 4.4.7 suggests the recipients server is at fault ... "Joe" wrote: ...
    (microsoft.public.windows.server.sbs)