| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif array function
Can any one suggest me the modification for the formula please?
=SUM(IF((exp!$C$3:$C$3000={4,5})*(exp!$D$3:$D$3000 ="School")*(exp!$G$3:$G$3000="cash"),exp!$L$3:$L$3 000)) In place of {4,5} can i give cell address say A1,B1. Then how the formula looks like? Sincere thanks to all Sridhar |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumif array function
You don't need to array enter if you use
=SUMPRODUCT((exp!$C$3:$C$3000=A1:B1)*(exp!$D$3:$D$ 3000="School")*(exp!$G$3:$G$3000="cash")*exp!$L$3: $L$3000) otherwise =SUM(IF((exp!$C$3:$C$3000=A1:B1)*(exp!$D$3:$D$3000 ="School")*(exp!$G$3:$G$3000="cash"),exp!$L$3:$L$3 000)) -- Regards, Peo Sjoblom "yshridhar" wrote in message ... Can any one suggest me the modification for the formula please? =SUM(IF((exp!$C$3:$C$3000={4,5})*(exp!$D$3:$D$3000 ="School")*(exp!$G$3:$G$3000="cash"),exp!$L$3:$L$3 000)) In place of {4,5} can i give cell address say A1,B1. Then how the formula looks like? Sincere thanks to all Sridhar |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumif array function
Many Thanks to you Mr. Peo Sjoblom. Not only uour suggestion solved my
problem but also it reduced some of my very long formulae to fit into the formula box. However sumproduct is not working with my data. I don't know it may be due to my data. Any suggestions My Sincere Thanks Sridhar "Peo Sjoblom" wrote: You don't need to array enter if you use =SUMPRODUCT((exp!$C$3:$C$3000=A1:B1)*(exp!$D$3:$D$ 3000="School")*(exp!$G$3:$G$3000="cash")*exp!$L$3: $L$3000) otherwise =SUM(IF((exp!$C$3:$C$3000=A1:B1)*(exp!$D$3:$D$3000 ="School")*(exp!$G$3:$G$3000="cash"),exp!$L$3:$L$3 000)) -- Regards, Peo Sjoblom "yshridhar" wrote in message ... Can any one suggest me the modification for the formula please? =SUM(IF((exp!$C$3:$C$3000={4,5})*(exp!$D$3:$D$3000 ="School")*(exp!$G$3:$G$3000="cash"),exp!$L$3:$L$3 000)) In place of {4,5} can i give cell address say A1,B1. Then how the formula looks like? Sincere thanks to all Sridhar |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumif array function
Explain what not working means, give some examples, and check the data for
any anomalies. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "yshridhar" wrote in message ... Many Thanks to you Mr. Peo Sjoblom. Not only uour suggestion solved my problem but also it reduced some of my very long formulae to fit into the formula box. However sumproduct is not working with my data. I don't know it may be due to my data. Any suggestions My Sincere Thanks Sridhar "Peo Sjoblom" wrote: You don't need to array enter if you use =SUMPRODUCT((exp!$C$3:$C$3000=A1:B1)*(exp!$D$3:$D$ 3000="School")*(exp!$G$3:$G$3000="cash")*exp!$L$3: $L$3000) otherwise =SUM(IF((exp!$C$3:$C$3000=A1:B1)*(exp!$D$3:$D$3000 ="School")*(exp!$G$3:$G$3000="cash"),exp!$L$3:$L$3 000)) -- Regards, Peo Sjoblom "yshridhar" wrote in message ... Can any one suggest me the modification for the formula please? =SUM(IF((exp!$C$3:$C$3000={4,5})*(exp!$D$3:$D$3000 ="School")*(exp!$G$3:$G$3000="cash"),exp!$L$3:$L$3 000)) In place of {4,5} can i give cell address say A1,B1. Then how the formula looks like? Sincere thanks to all Sridhar |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumif array function
I am sorry i entered the formula wrongly. My sincere thanks to you Mr. Bob.
My heart felt thanks to Peo Sjoblom Sorry for my mistake and inconvinience caused. Sridhar "Bob Phillips" wrote: Explain what not working means, give some examples, and check the data for any anomalies. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "yshridhar" wrote in message ... Many Thanks to you Mr. Peo Sjoblom. Not only uour suggestion solved my problem but also it reduced some of my very long formulae to fit into the formula box. However sumproduct is not working with my data. I don't know it may be due to my data. Any suggestions My Sincere Thanks Sridhar "Peo Sjoblom" wrote: You don't need to array enter if you use =SUMPRODUCT((exp!$C$3:$C$3000=A1:B1)*(exp!$D$3:$D$ 3000="School")*(exp!$G$3:$G$3000="cash")*exp!$L$3: $L$3000) otherwise =SUM(IF((exp!$C$3:$C$3000=A1:B1)*(exp!$D$3:$D$3000 ="School")*(exp!$G$3:$G$3000="cash"),exp!$L$3:$L$3 000)) -- Regards, Peo Sjoblom "yshridhar" wrote in message ... Can any one suggest me the modification for the formula please? =SUM(IF((exp!$C$3:$C$3000={4,5})*(exp!$D$3:$D$3000 ="School")*(exp!$G$3:$G$3000="cash"),exp!$L$3:$L$3 000)) In place of {4,5} can i give cell address say A1,B1. Then how the formula looks like? Sincere thanks to all Sridhar |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif/lookup ? Array | Excel Discussion (Misc queries) | |||
| and < for Array Sumif ({}) | Excel Worksheet Functions | |||
| Sumif and changing array | Excel Discussion (Misc queries) | |||
| use sumif with array | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Linear Mode
