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

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

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


"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

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

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

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Asif" wrote in message
...
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