Not sure if you can help me on this formula dilemma...
Here's what I want to see but this formula doesn't work:
{=SUM((SW!$I$4:$I$49,"=Client Financial Issues ")*(SW!$H$4:$H$49="lost"),SW!$D$4:$D$49)}
In english:
If range I4:I49 on the SW tab equals Client Financial Issues AND range H4:h49 equals Lost, then sum the amount in column D
In plain english, I want to know the reasons of lost accounts only and with their $ volumes.
If you could help, I would be grateful.
THANK YOU.
Here's what I want to see but this formula doesn't work:
{=SUM((SW!$I$4:$I$49,"=Client Financial Issues ")*(SW!$H$4:$H$49="lost"),SW!$D$4:$D$49)}
In english:
If range I4:I49 on the SW tab equals Client Financial Issues AND range H4:h49 equals Lost, then sum the amount in column D
In plain english, I want to know the reasons of lost accounts only and with their $ volumes.
If you could help, I would be grateful.
THANK YOU.