Hi,

You may also try this

=sumproduct((Status="APPROVED")*(Br_Code=219)*(Amo unt))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Fazli Wahid" <Fazli wrote in message
...
I am appliing 2 Codition to add data from excel worksheet howvere it dose
work and the result is Zero. Plaese help me throgh email.

{=SUM(IF((Status="APPROVED")*(Br_Code="219"),Amoun t,"-"))}