Sumproduct Function

E

excellover

The input in the example I gave for the cell references SHOUD READ :-

1) I put the command
SUMPRODUCT((A1:A5=F2)*(B1:B5=F3)*(C1:C5))

duane , sorry for the confusion , I was testing other references .
Bernard , I will try the command
Frank , any suggestions ?

Thank you all
 
Top