# Thread: moving columns? (office XP)

1. ## 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. ## 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. ## Re: moving columns? (office XP)

This sums the amount of "B"s or "S"'s in induvidual cells.

4. ## Re: moving columns? (office XP)

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

5. ## 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
•