| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Thanks for clarifying that. I was under the impression that all array
formulas had to be entered with Ctrl-shift-enter. Alok Joshi "JE McGimpsey" wrote: Well, it is an array-formula, but it doesn't need to be entered with CTRL-SHIFT-ENTER. In article , "Alok" wrote: The formula is as follows =SUMPRODUCT(--(F3:F326="2-Color"),--(L3:L326="4"),--(N3:N326="1"),M3:M326) Please note that this is an array formula and has to be entered with Control-Shift-Enter. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
| Array Function with VLOOKUP | Excel Worksheet Functions | |||
| Can I count in an array based on a function? | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
Threaded Mode
