SUMPRODUCT help

[Asif]

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.

 

[xlmate]

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

 

[Teethless mama]

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

 

[T. Valko]

Try it like this:

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

 

[Asif]

Thank you very much. This works.

--
Thanx & regards,
Asif

Try it like this:

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

 

[T. Valko]

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

Thank you very much. This works.