O orda2000 Jun 29, 2004 #1 can someone help me? x 0 x 0 x 1 x 1 y 0 y 1 y 0 z 1 z 1 z 1 z 1 i want x = 2, y = 1 e z =4 thx to all
can someone help me? x 0 x 0 x 1 x 1 y 0 y 1 y 0 z 1 z 1 z 1 z 1 i want x = 2, y = 1 e z =4 thx to all
D Don Guillett Jun 29, 2004 #2 to just count, use COUNTIF. To sum column B, use SUMIF. Have a look in HELP index for both
E Earl Kiosterud Jun 30, 2004 #3 Orda, I guess you want a count of each letter in the first column where the second column is 1. For the x's: =SUMPRODUCT((A2:A12="x")*(B2:B12=1)) etc.
Orda, I guess you want a count of each letter in the first column where the second column is 1. For the x's: =SUMPRODUCT((A2:A12="x")*(B2:B12=1)) etc.
