SUMIF

  • Thread starter Thread starter Fazli Wahid
  • Start date Start date
F

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