View Single Post
  #1   Report Post  
Brad
 
Posts: n/a
Default Conditional summing

Column H has the heading 0-30 days
Column I has the heading 31-60 days
Column J has the headingi 61-90 days
Column K has the heading 91+ days

Column O as the definition of the items
CLEARED
SYSTEM ISSUE
NOT STARTED
PENDING POLICY

I want to create a table that count the number of times items were "cleared"
(or any other category) within all the time frames detailed above. For each
row of data information will only appear in one of the columns (H-K) with the
explaination of the item in column O.

Any suggestions?