Try something like this...

=IF(A1=<YourCriteria,SUM(D3:F16),"")

Rick


"phinsxiii" wrote in message
...
This may be a really stupid question, but here I go. I want an equation
that
will only summ cells in a row in a specific range of cells if one cell in
another range matches a set criteria. For example, I only want to sum
those
cells in range D3:F16 if the value in a cell located in cloumn A matches a
specific value. So if A1 is the only cell in column A that matches the
criteria, then D1:F1 are summed.