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.
|