functions help

  • Thread starter Thread starter orda2000
  • Start date Start date
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
 
to just count, use COUNTIF. To sum column B, use SUMIF.
Have a look in HELP index for both
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge from a table 3
X,Y,Z values to be extracted and posted respectively in excel 2
sumif to add more than one column of cells. 4
Help needed: Lookup & output of multiple values related to ID incolumn 1
many IF conditions 7
Transpose large data from columns to rows 3
Excel VBA Macro to do this? 19
How To Delete the Empty Rows 3

Back
Top