Saturday, January 3, 2015

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