Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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,"-"))} |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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,"-"))} |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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,"-"))} |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif | Excel Worksheet Functions | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |