can you provide a sample how your data is layout and your expected result


--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis









"Asif" wrote:

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