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.