Multiple Criteria Function along with Count function

Hi All,

I am currently attempting to create a formula (combination of several excel formulaes) to account for the following scenario (I will try my best to explain properly as I am new to the forum).

In my database, I currently have many cases which may undergo several sessions before an order is issued. However, I wish to only account for cases when Both Parties are Present (BPP) in the 1st Session and the total number of CWDN and CDISM orders given (when BPP in the 1st Session).

I have attached a single case which has undergone 3 sessions, BPP present at 1st Session and an CWDN order was given at the last session.

As you can see in the image below, the numericals, "1" indicate that is the 1st session held and the number "2" are the subsequent sessions held for the case.

SCT/10130 1 BPP CFFC ---> 1 CWDN case when BPP in 1st session
SCT/10130 2 BPP CWDN
SCT/10131 1 DFT CMO
SCT/10132 1 DFT CMO
SCT/10133 1 CON CMO
SCT/10134 1 DFT CMO
SCT/10135 1 BPP CFFC ---> 2 CWDN case when BPP in 1st session
SCT/10135 2 BPP CWDN
SCT/10136 1 DFT CMO
SCT/10137 1 DFT CWDN
SCT/10138 1 CON CMO
SCT/10139 1 DFT CMO
SCT/1014 1 CON CMO
SCT/10140 1 DFT CMO
SCT/10141 1 DFT CWDN

Thus the answer to be expected from this set of data would be as follows:

1) Total Number of CWDN orders when BPP in the 1st session = 2 (I have highlighted the scenario for your reference).
2) Total Number of CDISM orders when BPP in the 1st session = 0

Hope to hear from you guys soon!

God Bless,
Joseph

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.