Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formulas using multiple { }
Please see the following formulas and explanations / questions...
FORMULA ONE =SUMPRODUCT(('DATA ENTRY SHEET'!$A$2:$A$4=3)*('DATA ENTRY SHEET'!$B$2:$B$4=100)*('DATA ENTRY SHEET'!$C$2:$C$4="")*'DATA ENTRY SHEET'!$D$2:$D$4) This formula works fine. FORMULA TWO =SUMPRODUCT(('DATA ENTRY SHEET'!$A$2:$A$4="")*('DATA ENTRY SHEET'!$B$2:$B$4=100)*('DATA ENTRY SHEET'!$C$2:$C$4={"C","P","S","T"})*'DATA ENTRY SHEET'!$D$2:$D$4) And so does this one. Now I change FORMULA ONE first array from =3) too ={2,4,"A","B"}) and it works fine. No problem, but I notice that FORMULA ONE did not have a { } option in it before. PLEASE NOTE Now I change FORMULA TWO first array from = 3) too ={2,4,"A","B"}) and it's cell comes back with #N/A, now again FORMULA TWO already has an { } option in it, in its third array. PLEASE NOTE My question I guess would be is how to get the program to except multiple uses of { } Or any other help to get around it would be greatly appreciated. The way I see it is { } gives you the option to equel too multiple things, is there another way to tell it NE "not to equel too" but show everything else. Any suggestions or help!!!??? Thanks in advance to whom ever has my solution!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you use multiple if formulas with multiple choices? | Excel Worksheet Functions | |||
multiple IF formulas | Excel Worksheet Functions | |||
Multiple formats in a single cell with multiple formulas | Excel Worksheet Functions | |||
Sort multiple columns with multiple formulas without returning #R | Excel Worksheet Functions | |||
Multiple Formulas | Excel Discussion (Misc queries) |