Array formula (validate with Ctrl+Shift+Enter) :
=SUM((Sheet1!A1:A100="x")*Sheet1!B1:F100)
HTH
Daniel

I am trying to use VLOOKUP to return the sum of corresponding columns to the
reference i search for. for example on wksht 2, i want column B to return the
sum of columns B-F on wksht 1 if the cell in column A (wksht1) is X. I
currently have it set up as such, but i have multiple entries on wksht 1
column A that = X. Is there a way to code "retun the sum of columns B-F if
A=X for all values =X in column A?

I concede this probably sounds confusing, but i am not of a wordsmith mind
at the moment.