Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pkhoo4

    splicing formulas together

    skip, thank you so much, you are a life saver! peter
  2. pkhoo4

    splicing formulas together

    skip, this is for an analysis of channel distribution. I had left out the product and channel information. the second year would have less of a retention than the first year. how can i clip data for you to see? I think I am not stating the problem correctly.
  3. pkhoo4

    splicing formulas together

    skip, this will not solve problem. year 1 (2008) the sales * retention % year 2 (2009) the sales * retention % * retention % i tried sumproduct((c2:C5=yr),a2:a5,(b2:b5^yrnum)) where yr = current select year and yrnum = 2 for year 2 Alternatively, i was thinking of putting a 20 rows of...
  4. pkhoo4

    splicing formulas together

    skip, obviously, year2 would be sumproduct(--c2:c5=2009, a2:a5, b2:b5, b2:b5) missed that before i post thank you peter
  5. pkhoo4

    splicing formulas together

    hi skip, thank you for catching my error. Here's my question again For year 1, I would use sumproduct(--c2:c5=2008,a2:a5, b2:b5), for year 2, I would use sumproduct(--c2:c5=2008, a2:a5, b2:b5, b2:b5) but now I need to sum it to the nth year in a formula and seem to figure it out. is it...
  6. pkhoo4

    splicing formulas together

    hi need help here. I need to sum the product of sales and retention. For year 1, I would use sumproduct(a2:a3,b2:b3), for year 2, I would use sumproduct(a2:a3,b2:b3,b2:b3) but now I need to sum it to the nth year in a formula and seem to figure it out. is it possible to raise b2:b3 to a...

Part and Inventory Search

Back
Top