SUMIF
 

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,"-"))}

SUMIF
 

Please read/reply here in the newsgroup thread. Your array seems ok. Try
these amendments (a) replace "Amount" with "Amount+0". The "+0" bit will
coerce possibly text nums in "Amount" to real nums for correct summing. If
the above still doesn't cut it right, check the underlying data for this
matching condition: Br_Code="219". Is the 219 a text num? If its a real
number, remove the double quotes. Any joy? hit the YES below
--
Max
Singapore
---
"Fazli Wahid" wrote:
I am applying 2 Condition to add data from excel worksheet however it does
work and the result is Zero. Plaese help me throgh email.

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

SUMIF
 

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,"-"))}