Hi,

Use SUMIF.

=SUMIF(DATE RANGE, CRITERIA, SUM RANGE)

Govind.

AAMIFC wrote:

I have used Conditional sums before and have been able to sum columns. I
have now been assigned some new work and the format of the sheet is that I
need to sum the results by row. A simple answer is to transpose the sheet -
which is not really an option as it is used by many users how know the
format. Is there any way to sum the contents of a row using a condition?

Thanks