*I tried with the above options & succeeded *- but within the same
worksheet.

I request your help for the following:


Even in the same worksheet - while trying
=SUMPRODUCT(((A5:A10)=A2)*1,((B5:B10)=B2)*1,C5:C10 )
sometimes I got #Value & sometimes #NA.

I am not sure - whether that is due to the fact that when I write
apr-06, in the column, it automatically gets converted to Apr-06 with
right alignment, indicating date format. The validating value however
was based on dropdown list using DATA-- VALIDATION option. Trying
to find out the error, it indicated data type mismatch. When I tried
to convert the contents to text also - it didn't succeed - since
Apr-06 got converted as 38808. This left the column cells with no. &
the validation cell with the text.


- Further I could not succeed in getting the sum value of column 'C'
of Sheet1, in a cell in Sheet2, based on sumproduct option used to
validate column 'A' & 'B' values of Sheet1.


Kindly guide me.

jitu


--
jitu_tikili
------------------------------------------------------------------------
jitu_tikili's Profile: http://www.excelforum.com/member.php...o&userid=33119
View this thread: http://www.excelforum.com/showthread...hreadid=529327