Try this:

=SUMPRODUCT((A1:A6000=P24)*(B1:B6000=P25)*(C1:C600 0=P26)*(D1:D6000=INDEX(AA1
:AA10,MATCH(P27,Z1:Z10,0)))*E1:E6000)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Hari" wrote in message
oups.com...
Hi,

I have 5 columns of Data (Column A through E).

I need to sum data in Col E based on satisfaction of conditions in Col
A through D.

Value in Col A should match val in p24.
Value in Col B should match val in p25.
Value in Col C should match val in p26.

(So far so good, I know I could have used sumproduct to solve, but...)

Its the column D which has been a problematic one. The value in P27
corresponds to a small table in Z1:AA10 (Basically P27 might be present
in any one of the cells Z1 through Z10). Now, whenever Cell P27 and
Cells Z1 hrough Z10 matches, then the corresponding value in Column AA
needs to be matched with the Column D values.

How to solve this? (I have 6000 rows of data and I would need to do
sumproduct summarizaton for many cells.)

regards,
HP
India