SUMPRODUCT Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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)
 
Sumif would work for this

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