Assume your names in Sheet1 are in column A, the dates are in column
D, and the values you want to add are in column F. Further assume that
the target_name in this_sheet is in A2. Try this formula in a cell in
this_sheet:

=SUMPRODUCT(--(Sheet1!A2:A100=A2),--(MONTH(Sheet1!D2:D100)=4),Sheet1!
F2:F100)

Adjust the ranges to suit your data.

Hope this helps.

Pete

On May 17, 4:09*pm, Carrach wrote:
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