Conditional summing

B

Brad

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?
 
E

Earl Kiosterud

Brad,

You can make 16 different SUMIF formulas:
=SUMIF(O2:O11,"CLEARED",H2:H11)

Or make a pivot table. Drag your status (column O) heading into the row or
column area, and the four age column headings (H-K) into the data area. You
may have to change the function to SUM, if it's defaulted to COUNT.
 
Top