sum product

[jackdiamond]

Hi,

I am currently using this formula to find and return data for me.

=SUMPRODUCT(('DATA '!$C$6:$C$2000)*('DATA '!$B6:$B2000="GARETH WILLIAMS"))

I want it to add more data for the same person from another worksheet. The worksheet I now want the extra data from is called "datasheet data"

Does anyone know how I can write this into the above formula please? I cant get it to work the way I have tried

thanks
Stu

 

[Jonmo1]

I think you'll have to make anothe sumproduct formula, and add the 2 together...

perhaps like

=SUMPRODUCT(('DATA '!$C$6:$C$2000)*('DATA '!$B6:$B2000="GARETH WILLIAMS"))+SUMPRODUCT(('datasheet data'!$C$6:$C$2000)*('datasheet data'!$B6:$B2000="GARETH WILLIAMS"))

 

[jackdiamond]

worked perfectly.

thanks