Consejos para fórmula en Excel: Contar si otra celda cumple una condición

%3CLINGO-SUB%20id%3D%22lingo-sub-1532091%22%20slang%3D%22es-ES%22%3ETips%20for%20formula%20in%20Excel%3A%20Count%20if%20another%20cell%20meets%20a%20condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1532091%22%20slang%3D%22es-ES%22%3E%3CP%3EHello!%26nbsp%3B%3CBR%20%2F%3EI%20have%20a%20question%20about%20whether%20I'm%20using%20the%20right%20formula%20or%20if%20I%20should%20use%20another%20one.%20%3CBR%20%2F%3E%20The%20one%20I'm%20trying%20to%20doesn't%20get%2C%20but%20maybe%20I'm%20just%20making%20it%20wrong.%20%3CBR%20%2F%3E%20I%20would%20need%20to%20count%20profits%3B%20then%20from%20a%20price%20list%20I%20want%20to%20count%20only%20those%20that%20in%20the%20first%20column%20say%20%22Sold%22.%26nbsp%3B%3CBR%20%2F%3EI've%20been%20putting%20%22ADD.SI(J%3AJ%2C%22Sold%22%2CA%3AA)%20But%20it%20doesn't%20take%20it%20as%20right.%20%3CBR%20%2F%3E%20I%20have%20the%20prices%20in%20the%20J%20and%20I%20need%20those%20values%20to%20be%20added%20only%20if%20in%20column%20A%20it%20says%20%22sold%22.%20%3CBR%20%2F%3E%20I%20hope%20someone%20can%20help%20me%2C%20thank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1532091%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1532206%22%20slang%3D%22en-US%22%3ERe%3A%20Consejos%20para%20f%C3%B3rmula%20en%20Excel%3A%20Contar%20si%20otra%20celda%20cumple%20una%20condici%C3%B3n%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1532206%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F733254%22%20target%3D%22_blank%22%3E%40Valo_%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20SUM%20the%20prices%20for%20all%20Sold%20rows%2C%20switch%20the%20A%3AA%20and%20J%3AJ%20the%20other%20way%20round.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20believe%20in%20Spanish%20this%20should%20be%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSUMAR.SI(A%3AA%2C%22Sold%22%2CJ%3AJ)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20COUNT%20the%20Sold%20rows%2C%20use%20the%20COUNTIF%20function.%20I%20think%20in%20Spanish%20it%20should%20be%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DCONTAR.SI(A%3AA%2C%22Sold%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22OwenPrice_0-1595200704210.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F206296iA197A1E808F53035%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22OwenPrice_0-1595200704210.png%22%20alt%3D%22OwenPrice_0-1595200704210.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hola! 
Tengo una duda sobre si estoy usando la fórmula correcta o si debería usar otra.
Con la que intento no me sale pero quizás solo la estoy formulando mal.
Necesitaría contar ganancias; entonces de una lista de precios quiero contar solo los que en la primera columna dicen "Vendido". 
Estuve poniendo =SUMAR.SI(J:J,"Vendido",A:A) Pero no me lo toma como correcto.
Tengo los precios en la J y necesito que se sumen esos valores ÚNICAMENTE si en la columna A dice "vendido".
Espero que alguien pueda ayudarme, gracias de antemano.

1 Reply

@Valo_ 

 

If you want to SUM the prices for all Sold rows, switch the A:A and J:J the other way round.

 

I believe in Spanish this should be:

 

=SUMAR.SI(A:A,"Sold",J:J)

 

To COUNT the Sold rows, use the COUNTIF function. I think in Spanish it should be:

 

=CONTAR.SI(A:A,"Sold")

 

OwenPrice_0-1595200704210.png