Monday, June 20, 2011

yogi_Count Cells In Specified Columns From Rows That Meet Specific Condition

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
Sam Cycling said:
if a cell contains specific text, sum/count cells from multiple columns in same row if cells are not empty
I am having trouble working out what formula I would use to count the number of cells in a row that are not empty based on if say B101 contained A2:
I have about 20 rows of data, column B holds the names of schools, then columns: C, G, K, O, S and W hold names of children however there maybe some times where there is no child's name.
I need to compare the name of the school in column B against another cell further up the spreadsheet to see if they match, then if that row has the same school name, count/sum up the number of children in columns B, F, J, N, R and V.
----------------------------------------------------------------