Wednesday, November 7, 2012

yogi_Using Workaround For Excel's COUNTIFS Function With Fractions In Google Spreadsheet


                                           Google Spreadsheet   Post  #858
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 07, 2012
user liqt said : (http://productforums.google.com/forum/?zx=xdgf04nj8c5p#!category-topic/docs/spreadsheets/bOOatncfl7U)
countif equivalent involving fractions
hi i have a problem regarding this formula

 =COUNTIFS(A:A,"AAAA",B:B,"Yes") & "/" & COUNTIF(A:A,"AAAA") & "AAAA"

AAAA
AAAA
BBBB
BBBB
CCCC
CCCC
CCCC

this formula is from excel which basically count's the number of AAAA's/yes' (should display as a fraction) which however works however i want to expand this by, it should know how many AAAA's there are as for exampe, there are 4 AAAA's but only 2 AAAA's signed up so it would display 2/4

does anyone understand what im trying to say? if anyone could help, it would help me so much~
thanks

------------------------------------------------------------------------------------------------------
following is a workaround solution to the problem