hey ...
thanx for the info... that definetly helped. i was hoping if u could
help me with one more problem... when we create a drop down menu in
excel.. how can we make the data that needs to be present in the list
appear only in the drop-down list and not in the cells? thanx again in
advance...
adi
patele wrote:
I'm sure there's other ways but here's one:

On sheet 'machine hrs' put the following:

=SUMIF(Data!B1:B5,120,Data!A1:A5)

This will look up the 120 on the data sheet and returns 25 as the
total.

Hope this helps you.


--
patele
------------------------------------------------------------------------
patele's Profile: http://www.excelforum.com/member.php...o&userid=35849
View this thread: http://www.excelforum.com/showthread...hreadid=561228