functions help

O

orda2000

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

to just count, use COUNTIF. To sum column B, use SUMIF.
Have a look in HELP index for both
 
E

Earl Kiosterud

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.
 
Top