I would like to use a range but rather than the values for the elements being in cells A1:A4 for example, they are scattered about the sheet, for example A1, B3, D7, E10.
I am looking for a formula that will produce something equivalent to =A1:A4, for example =createrange(A1, B3, D7, E10)
Many thanks in advance.
Max
You can select desired cells (A1, B3, D7, E10) and name range as you like (i.e. test)
then you can use formula =SUM(test) to sum values in it.
Never use Merged Cells in Excel
Thank you. This works when using sum but doesn't work for =MMULT(test,TRANSPOSE(test)) the formula I want to use.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks