Thanks Ardus.
Type in col. E has a numeric value.
I have modified the formula slightly as below but it doesn't worl and
returns zero.
=SUMPRODUCT((FE!A1:A9999=A7)*(FE!B1:B9999=B7)*(FE! C1:C9999=C7),FE!E1:E9999)

Any suggessions?

Regards,
Madiya



Ardus Petus wrote:

=SUMPRODUCT((FE!A1:A999=A1)*(FE!B1:B999=B1)*(FE!C1 :C999=C1),FE:E1:E999)

This works if type in col. E has a numeric value.

HTH
--
AP

"Madiya" a écrit dans le message de news:
...
I need to fatch a value by vlookup from 3 criteria. Here are the
details.

In my sheet FE col A has dates, B has names, C has type and E has
value.
Dates and value will change daily while name and type is constant.
Every day new row is added in the table. Hance name and type will be
repeared on daily basis.

In sheet Summary, I entered date, name and type.
I need to fatch a value from sheet FE, col E where date, type and name
matches the corresponding value in sheet FE.

Is it possible without VBA? I would prefer a solution with formulas if
possible.

Regards,
Madiya