• 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. R

    SumIf Help [SOLVED]

    I have a simple problem. Say I have a range of cells with some numbers B1:D1 I want to only add the cells if the cells below contain a number B2:D2 I know I can write a simple formula =If(B2<>0,B1,0)+If(C2<>0,C1,0)... That gets to be too long if my range is B1:Z1! I know...
  2. R

    Rept function

    Would it be possible to add a separator in the rept function so that my data would show 5 I's then a space, then 5 more I's? =rept("I",10) IIIII IIIII instead of IIIIIIIIII
Back
Top