If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
help with formulas
I have a list of applications that have gone overdue. Here is a sample of my
list: Program Code Case # Delay Code P60 401133012 P60 721283900 AG P30 821362112 P30 828190110 P60 950351513 CI L60 217075010 CI S60 810474413 OA Q30 235391903 OA S60 167004803 OA S30 893474708 OA S30 676254115 CI S60 712233808 There are several different program codes for the applications, and a few different delay codes, leading to several different needs to count for the list. I am trying to figure out how I can count, for example, the number of P60 applications that had a delay code of "CI", or the number of Q30 applications that had a delay code of "OA", or the number of S60 applications that had no delay code, etc. Please help! |
#2
|
|||
|
|||
help with formulas
=SUMPRODUCT(--(A2:A20="P60"),--(C2:C20="CI"))
=SUMPRODUCT(--(A2:A20="Q30"),--(C2:C20="OA")) or =SUMPRODUCT(--(A2:A20=D2),--(C2:C20=E2)) where D2=Program Code E2=Delay Code Click yes if helped -- Greatly appreciated Eva "Bradly" wrote: I have a list of applications that have gone overdue. Here is a sample of my list: Program Code Case # Delay Code P60 401133012 P60 721283900 AG P30 821362112 P30 828190110 P60 950351513 CI L60 217075010 CI S60 810474413 OA Q30 235391903 OA S60 167004803 OA S30 893474708 OA S30 676254115 CI S60 712233808 There are several different program codes for the applications, and a few different delay codes, leading to several different needs to count for the list. I am trying to figure out how I can count, for example, the number of P60 applications that had a delay code of "CI", or the number of Q30 applications that had a delay code of "OA", or the number of S60 applications that had no delay code, etc. Please help! |
#3
|
|||
|
|||
help with formulas
Hi,
Create a pivot table with Program code in the row area, Delay code in the column area and Case# in the data area. If the data area shows sum, then right click and change the field settings to count -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Bradly" wrote in message news I have a list of applications that have gone overdue. Here is a sample of my list: Program Code Case # Delay Code P60 401133012 P60 721283900 AG P30 821362112 P30 828190110 P60 950351513 CI L60 217075010 CI S60 810474413 OA Q30 235391903 OA S60 167004803 OA S30 893474708 OA S30 676254115 CI S60 712233808 There are several different program codes for the applications, and a few different delay codes, leading to several different needs to count for the list. I am trying to figure out how I can count, for example, the number of P60 applications that had a delay code of "CI", or the number of Q30 applications that had a delay code of "OA", or the number of S60 applications that had no delay code, etc. Please help! |
Thread Tools | |
Display Modes | |
|
|