Thursday, August 11, 2011

yogi_Counting Numbers And Strings In One Column Based On Value In Another Column

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

gwrath said:
Counting numbers and "string" in column C where column B = Y
OK so I have been trying to count the occurrences of "1" and the charcters "BF" which appear in column C based on the presence of a client name in column B - I am basically trying to summarise by client the instances of these in another sheet.
I basically want the count of instances of 1 and BF in column C in the DATA sheet to appear in column C of the SUMMARY sheet.
I have tried using CountA but don't know how to make it only look at the rows containing the correct client, the number of these rows will of course be variable.