Thursday, August 29, 2013

yogi_Count Instances Of A Specified Character In Column B When Column A Equals Another Specified Value

                                          Google Spreadsheet   Post  #1349
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug 29, 2013
user amj05 (http://productforums.google.com/forum/?zx=2cathjan7ij1#!category-topic/docs/spreadsheets/zgI4vGlrwSo)
Count instances in an array if
If I have two columns that look like this:

AX, Y
BY
CX, Z
BX, Y, Z
DZ
AY, Z
AX, Y, Z

Is there a formula to count the total number of times Y appears to the right of A (whether or not Y appears with anything else)? The only way I know involves way too many lines (especially since there will be more variables than in this example). Thank you!
----------------------------------------------------------------------------------------------------------------------------------------------------