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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by pkhoo4

  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...
See more

Part and Inventory Search

Back
Top