Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Boell Fischer   on Jan 13 In MS Office Category.

  
Question Answered By: Zachary Larson   on Jan 13

i just want to know how to the SUM function  works. i need a function
that can combine some cells' value in one grid. for instance, there's
A1:Hello
B1:World
C1:=combine(A1,B1) <---- the value of C! will be "HelloWorld"
and the variants in combine() depends on user's selection  then it can
be like this
+--------------+
| A1 |
| B4 |
| G5 |
| ... |
+--------------+

maybe it will like this? but i am not sure.
function combine(a as range)
for each x in ...
combine+=cells(x).value
next x
end function

Share: 

 

This Question has 11 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on custom Sum function? Or get search suggestion and latest updates.


Tagged: