Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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. -- Earl Kiosterud www.smokeylake.com "Brad" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Summing (Sumif? Countif?) | Excel Worksheet Functions | |||
Conditional Summing | Excel Discussion (Misc queries) | |||
Conditional summing with large amounts of data | Excel Worksheet Functions | |||
"Conditional" summing | Excel Worksheet Functions | |||
conditional Summing | Excel Worksheet Functions |