Hi,
Wonder if anyone could put me on the correct track?
I need to show the totals for the following:
(if target_name_sheet1=target_name_this sheet)and(if
actual_month_sheet1=4)then total actual_value_sheet1for month 4. and place in
cell E6 this sheet.

(hope you can follow that)
I think that it should be a SUMPRODUCT function but not sure how to put it
together.

--
any help gratefully received
thanks
carrach