moving columns? (office XP)

Topic

New Reply

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 B2:D2 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.

Reply | Quote

Replies

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

How about: =SUM((B2=”B”),(I2=”B”),(M2=”B”))
This sums the amount of “B”s or “S”‘s in induvidual cells.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

How about: =SUM((B2=”B”),(I2=”B”),(M2=”B”))
This sums the amount of “B”s or “S”‘s in induvidual cells.

Reply | Quote