sum if condition is met

[QlikFudd]

Hi, hope someone can help me.
Here's my data

Name	From	1st interview	offer	withdrawn	Started	desired
Totals	3	2	1	2	1	1
aaaaaaaa	1	1	1	1	0	1
bbbbbbb	1	0	0	1	0	0
ccccccccc	1	1	0	0	1	0

I would like to make the desired column. Logica: if a name is withdrawn after having an offer then 1. If a name is withdrawn but had no offer then 0.........

The columns are made this way: 
offer: SUM(IF(UserTrackTypeExtended='Offer', 1))
withdrawn: Sum([#IsWithdrawTrack])

Thank you for your help!
Regards, Elmer

[BrunPierre]

It's more efficient to handle this logic by creating flags in the back end and rely on simple sum expressions at the front end.

You may want to provide a sample of the data and the expected output for assistance.