Try this:

=SUMIF(R9:R12,A6,M9:M12)

--
Biff
Microsoft Excel MVP


"Jeannine" wrote in message
...
I am trying to lookup an exact value (1113) in one cell and one column.
then
move across the row to a different colunm to add the values in that
column.
If I do as follows:
=IF(A6=R9,M9,0)+IF(A6-R10,M10,0)+IF(A6=R11,M11,0)+IF(A6=R12,M12,0)

It works just fine but if I have 40 rows that is a lot of IF's. Is their
a
way to do this in a shorter way. the value is in "A6" AND I am searching
column "R" for an exact match. If I find matches in "R" then I wanted the
value on the same rows in Column "M" added together.

I hope this makes sense - I would appreciate your help - thanks in advance