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.
Bookmarks