how to find all instances and then add all numbers

[shnay]

I have this formula but I need it to find all instances and total up the result found in column 10 from each instance. Right now it just finds the first one and copies whats in column 10.

Here is the formula I have
=IF(ISERROR(VLOOKUP($A6,PREInvoice!$C$22:$L$42,10,0)),0,(VLOOKUP($A6,PREInvoice!$C$22:$L$42,10,0)))

[Paul]

Hi Shnay,

VLOOKUP only returns the first match found. You might want to try SUMIF or SUMPRODUCT, for example:

=SUMIF(PREInvoice!$C$22:$C$42,$A6,PREInvoice!$L$22:$L$42)

or

=SUMPRODUCT(--(PREInvoice!$C$22:$C$42=$A6),PREInvoice!$L$22:$L$42)

Hope that helps!