COUNTIF using # ranges, and referencing 2 other columns

C

crafty_girl

I know there has to be a way to do this but can't figure it out. Does this
look like something anyone can assist with!?

(early-late) Line Biz Unit
Col D Col G Col H
10 VOLUME IPG
80 VOLUME PSG
-160 VALUE IPG
20 VOLUME TSG

GOAL:
IF Col G = Value & Col H = IPG, count occurrences greater than 10 days,
count occrences between 5-10 days, etc. for each grouping.

(col G) (col H)
VALUE IPG
COUNT numbers matching the below ranges (found in col D).

No Data
Early >10 days (>10)
Early 5-10 days (>4 & <11)
Early 3-4 days (>2 & <5)
Early 1-2 days (>0 & <3)
On-Time (=0)
Late 1-2 days
Late 3-4 days
Late 5-10 days
Late > 10 days (<-10)

(col G) (col H)
VALUE PSG
COUNT numbers matching the below ranges.

No Data
Early >10 days (>10)
Early 5-10 days (>4 & <11)
Early 3-4 days (>2 & <5)
Early 1-2 days (>0 & <3)
On-Time (=0)
Late 1-2 days
Late 3-4 days
Late 5-10 days
Late > 10 days (<-10)

REST OF THE LIST OF SEGMENTS TO COUNT FOR…
VALUE TSG
VALUE NO PRODUCT GROUP
VALUE CORP AND OTHER SEGMENT
VOLUME IPG
VOLUME PSG
VOLUME TSG
VOLUME NO PRODUCT GROUP
VOLUME CORP AND OTHER SEGMENT
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top