SUMIF

[Fazli Wahid]

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

 

[Max]

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

 

[Ashish Mathur]

Hi,

You may also try this

=sumproduct((Status="APPROVED")*(Br_Code=219)*(Amount))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com