Adding values from diff rows + columns

  • Thread starter Thread starter Amanda
  • Start date Start date
A

Amanda

Hello,
I'm trying to add values together which are from different rows.
I have data in values cells k72:aj72 and would like to add it to
values that are in cells k45:aj72. There is other data, that I do not
want, between the rows, so I can't just add down the columns. I tried
=sum(k72:aj32 + k45:aj45), but this doesn't work.
Does anyone know how I can do this??

Thanks
~Amanda
 
Amanda,

Use you formula, but as an array formula, that is commit with
Ctrl-Shift-Enter, not just Enter.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thanks Don!! That worked.

Thanks Bob, I tried ctrl+shift+enter, but I have the cell, that I wan
the value in, merged and it wouldn't accept an array in merged cells.


Thanks again, guys!

~Amand
 
Back
Top