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!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formulas using multiple { }
=SUMPRODUCT(('DATA ENTRY SHEET'!$A$2:$A$4={2,4,"A","B"}) *('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) worked fine for me, but it doesn't use an OR logic. I doubt it is what you want. -- Regards, Tom Ogilvy "Sean" wrote in message ... 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!!! |
Reply |
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) |