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,"
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
No comments:
Post a Comment