yogi_Count Of Attributes Based On Specified Criteria

             Google Spreadsheet   Post  #1875

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-03-2015

post by  Carlos Sanchez:
COUNT IF (en función de otra celda) (IF COUNT (depending on another cell))

Hi I have a table:

Column 1 Column 2

Blue 7

Red 23

Red 2

Red 9

Blue 3

Blue 0

QUESTION 1: I want to make a COUNTA function of the value in column 1 (it = blue). That is, IF COLUMN 1 COLUMN = blue then COUNT 2. The result should be the end for this example = 3. What is the function?

QUESTION 2: Same as above but only make a COUNT COLUMN 2 if in addition the value of IS DIFFERENT FROM COLUMN 2 0. The result for the above example would be = 2.

Thanks in advance.
---------------------------------------------------------------------------------------------------------------------