Hi Brian,

a couple of options:

=SUMPRODUCT(SUMIF(B1:E1,{"Company A","Company B"},B2:E2))

=SUMPRODUCT((B1:E1={"Company A";"Company B"})*B2:E2)

The fixed arrays can be replaced by range references: in the 2nd formula the
range must be vertical (or horizontal with TRANSPOSE function).

Regard,
KL


"Brian Barbre" wrote in message
...
I have a row of data that I want to sum if the corresponding collumns are
one
of several departments. I can't figure out how to use multiple criteria
with
the sumif function and the data is not in typical DB format so I can't use
the DSUM function. Does anyone know how to solve this problem?

Thanks in advance,

Brian

Sample
Company A Company B Company C Company D
Assets 15 5 20 25

Question: What are the assets for companies A and B.
My actual situation could have 15 different search requirements.