Closed Thread
Results 1 to 2 of 2

Duplicate post >> Formula Issues

  1. #1
    Registered User
    Join Date
    09-27-2007
    Posts
    4

    Duplicate post >> Formula Issues

    Hello, I have been trying to figure out to get specific results on a file I have been working on with formulas and I am at a complete loss.

    The file actually contains two separate worksheets, but I lumped everything onto one in this image.



    What I am having trouble with is creating a formula that uses the YTD Sales from the first table (and excludes zeros or negatives YTD companies) to create a column that lists the occurrences of the SIC Codes for companies with sales over zero.

    Also, I'd like to create a chart or table that lists the total $ per sic code (for companies with YTD sales over $0) per state.

    Ignore the $ per SIC Code column and the average column. Those I know how to do. I was just getting lazy making this sample.

    If anyone can help me figure this out, I would be extremely grateful. I have been messing with this the last couple days and I want to bash my head or my computer against the wall.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Hi

    Double post


    refer

    rylo

Closed 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