Thank you very much. This works.

--
Thanx & regards,
Asif


"T. Valko" wrote:

Try it like this:

=SUMPRODUCT(($A$201:$A$300=$A310)*$O$201:$T$300)


--
Biff
Microsoft Excel MVP


"Asif" wrote in message
...
Hi,

I am trying to sum across a range of columns using following formual:

=SUMPRODUCT(($A$201:$A$300=$A310),$O$201:$T$300)

But it errors out. I tried to use SUMIF but didn't work either. Is there a
way to sum across a range of columns.

--
Thanx & regards,
Asif