Show result of a SUM in a VLOOKUP
Try this:
A2 = client
=SUMPRODUCT((Update!A2:A10=A2)*Update!B2:F10)
Biff
"Sarah (OGI)" wrote in message
...
I need to use a vlookup and sum function (I think) in an Excel 2000
workbook
with two worksheets. The Update worksheet shows client ref in column A,
then
along each row, shows various monetary values of business done by each
client. The Summary worksheet also shows the client ref in column A, but
I
need this worksheet to sum each of the values entered on a row, but pull
out
the the result of the sum by doing a vlookup on the client ref.
Thanks in advance!
|