=SUMPRODUCT(Invoices!A:A=A22,Invoices!G:G)
doesn't work

I am in worksheet B that looks up a project number in column A of worksheet
A against the same match in column A of invoice schedule worksheet A then
when it the contents match in whole column of worksheetb column A it adds ALL
the contects of WSB column G, but not first find , all of the matches. I have
several invoices issued under a project number.

WSB
A B G
proj nr - invoice nr - ,,,,, £3000 (sum invoiced)


WSA
A H
proj nr,,,,,,, total invoiced <<<this formula reqd that looks up
same proj number as wsa in column wsbA and gives me total of where matches of
wsbG

not sure if that explains it I am not too technical, sorry, thanks for help!

sph



"Mike H" wrote:

Hi,

Do you mean this

=SUMPRODUCT((A2:A5=E2)*(C2:C5))

Mike

"Spheon" wrote:

=IF(ISNA(VLOOKUP(E2,$A$2:$C$5,3,FALSE)),0,VLOOKUP( E2,$A$2:$C$5,3,FALSE))

Hi I have managed to get this formula to work but I dont want the result to
end at the first find, I want to find all that are the same as E2 in range to
sum all in column 3.

Is this possible, I dont really want to create a pivot table and getdata
etc, surely there is a way but I am scratching my head :(

thanks in advance