• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. L

    Sum by groups

    Very Helpful Narayan. I didnt know about the * and ?. Thank you for your help.
  2. L

    Sum by groups

    Thanks Narayan, Its working just perfect. Can you explain to me the formulae =Countif(S39:$S$48;S39&"*") What does the second part mean? S39&"*" I came up with other solution, but its way more complicated. Its in the file updated. Thank you
  3. L

    Sum by groups

    Lets start with the 1.1.1.1 - this one is done eith the budget column so its 1 The 1.1.2, 1.1.3 and 1.1.4 are the same. The Total column is due to the budget column 1.1.1 is the sum of 1.1.1.1 so its 1 too If I had 1.1.1.2 it would have sum it too The 1.1 is the sum of 1.1.1, 1.1.2, 1.1.3 and...
  4. L

    Sum by groups

    What I want to do is calculate the Total Column. I make the budget out of one group and than the Total Column should give me the amount based on groups below it. The Columns "Level", "1", "2", "3", "4" and Aux are just for Calculations. They are auxiliaries. What I really want to do is Sums...
  5. L

    Sum by groups

    Hello, my name is Luis and I'm from Brazil. I'm facing a problem that I could not come up to an idea to solve it. I create groups based on cell position 1 Group1 1.1 Group 2 1.2 Group 2 1.2.1 Group 3 1.3 Group 2 What I want to do is sum the different groups. The...
  6. L

    Changing one cell or Another

    Thanks Vaskov. I used your code and made some changes to it so the % could work. Now It works perfectly. Private Sub Worksheet_Change(ByVal Target As Range) ' Dim Valor As Single ' With Target If .Address = "$C$1" Then Valor = .Offset(0, 0).Value .Offset(1, 0).Value = Val(.Offset(0...
  7. L

    Changing one cell or Another

    Thanks, But it isn't what I meant. I have a total amount to spend, I could be 500 dollars (A1 = 500) Than I have two columns, one for % and the other for values (C1 and C2) If I use the C1 with 10, it will give me 50 in C2. If I write 100 in C2, it will give me 20% in C1. I want...
  8. L

    Changing one cell or Another

    I have two cells. One with values and another with %. I want to use the Value one and Excel calculates the other with %. If I change it and use the % cell, I want excel to calculate the Value. Example: -A1 = 500 -C1 is Value -C2 is % If I use C1 with 50 it will give me C2 = 10% If I use...
Back
Top