SUMPRODUCT Query

[Guest]

I am using a sumproduct function in a spreadsheet to calculate totals of
named ranges.

The calculation I am using is:

=SUMPRODUCT((First=A2)*(Second))

where first and second refer to two named ranges.

I have checked that all cells are the right format and that all named ranges
have been done properly....but it still will not work.

Any suggestions on where it might be going wrong. I have used it for one
set of named ranges and it works fine...but on this one it will not work.

Also - the data in the named ranges is the result of a formula and is in
percentages.

 

[Bob Phillips]

You don't say in what way it doesn't work, unexpected result, error result?

And you can simply use

=SUMIF(First,A2,Second)

In all cases, First and Secod must be the same size.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Don Guillett]

Sumif would work for this

Your ranges must be the same size and cannot be entire columns.

 

[RagDyeR]

Typo Don.

Thinking of Sumproduct when you referred to Sumif and entire columns.<bg>

 

[Don Guillett]

Thanks, RD
I meant to include a formula. Getting old, you know.