View Single Post
  #5   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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.