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