Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    moving columns? (office XP)

    hi, attached Excel file has A1:A23 = Date, B1= 1,2,.....16, R1= B and last column has S1= S. task here is to count how many B and S in each row and R2 has =COUNTIF(B2:Q2,"B") and S2 has =COUNTIF(B2:Q2,"S").

    now, i want to count not from a range cell like B22 or D2:F2 but at random cell like (B2 and F2) or (F2 and I2 and M2) to find the numbers of B and S in each row. does anyone knows how to do this? THANK YOU VERY MUCH.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: moving columns? (office XP)

    Not exactly clear what you are after.

    Are you after the rows that have Both a B and an S in them? then use:

    =AND(COUNTIF(B2:Q2,"B")>0,COUNTIF(B2:Q2,"S")>0)

    Steve

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: moving columns? (office XP)

    How about: =SUM((B2="B"),(I2="B"),(M2="B"))
    This sums the amount of "B"s or "S"'s in induvidual cells.
    Regards,
    Rudi

  4. #4
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: moving columns? (office XP)

    hi Rudi, your formula can fit my calculation at selected cell. THANK YOU VERY MUCH.

  5. #5
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: moving columns? (office XP)

    hi Steve, no, i am after the sum of numbers of B and the sum of numbers of S. the sum source must be at selected cells. destination of sum B numbers in one column and destination of sum S numbers in another column. THANKS for reply.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •