On Aug 1, 2:37*am, "kounoike" wrote:
"Stav19" wrote in message

...
On Jul 31, 12:31 am, "kounoike" wrote:





"Stav19" wrote in message

...
On Jul 30, 11:03 am, "kounoike" wrote:

--snip

- Show quoted text -
Apologies, I was trying to use what you'd given me in a different
spreadsheet, and it didn't seem to work, but tried the above using my
initial example, and it worked fine, I just need to figure out how to
change it to make it work. Thanks for your help on this!

Please show me what you did step by step. espeacially, your sheet's name
and
your data layout in that sheet etc.

keiji
The sheet is called "Values" data looks like this in columns A and B:
Point 1 * * * * *(%)
Asset * * * * * #.##
Asset * * * * * #.##
Asset * * * * * #.##
Point 2 * * * * (%)
Asset * * * * * #.##
Asset * * * * * #.##
Asset * * * * * #.##
Money1 * * * *£#.##
Money2 * * * *£#.##
Money3 * * * *£#.##
Money4 * * * *£#.##
Money5 * * * *£#.##
Money6 * * * *£#.##
Point 3 * * * * (%)
Country * * * *#.##
Country * * * *#.##
Country * * * *#.##
Point 4 * * * * (%)
Type 1 * * * * *#.##
Type 2 * * * * *#.##
Type 3 * * * * *#.##
xxx
Apologies for the size, but I've tried to keep it short, basically in
column C i'd like to sum up the percentages of "points 1-4"
separately, and also the amount of money. *Basically in the future,
the amounts of data in each little group will change, I wanted to be
able to ensure the spreadsheet can deal with that.
I appreciate any help you can give me!

Because of *my poor English ability, I can't fully understand what you want
to do.
You said in your first post that when you run my macro, there's a run time
error
as an object is required. But i can't think of any causes why that happened,
although, in my thought, it will give you wrong results or it will do
nothing.

Do you want a sum of percentages of "points 1-4" separately in column C and
at the same time, do you want a sum of money, if it exists, of "points 1-4"
separately in column C? In that case, in which position should a sum of
money reside?

I think it's diffcult to know which is percentages and which is money
without any marks like (%) and same sets, in this case percentage and money
should *reside continuously. if not, it would be more difficlut to sum up.

Sorry for being without any help.

keiji- Hide quoted text -

- Show quoted text -

Hi Keiji

you've already been a great helpm thanks!