Saturday, November 11, 2017

yogi_Count Row By Row Blank Cells From Row 5 Down Based On Projects Listing In Row 1

Google Spreadsheet   Post  #2280

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-11-2017
question by: Yannick Rachel
https://productforums.google.com/forum/?nomobile=true#!topic/docs/m5Y84o4UGDg;context-place=topicsearchin/docs/authorid$3AAPn2wQc7O4EQsX1gkj1mKYiVqjACnXxOUJfDW9aP6REEoSb26rzIBkrBhpHOgIm3cS21f6-y3rVl%7Csort:date%7Cspell:false
Countblank with expanding columns
Hi through a MMORPG my job is to track the contributions of guild members to various projects.
On my table, rows 1,2 and 3 are the project originator, the name of the project and the start date. This starts from column C.
Column A lists all the guild members.
When a guild member has contributed to the project, I will put a Y on their row, at the project column.
Column B is my problem. Right now column 2 counts the outstanding contributions for each guild member with the formula:
=COUNTBLANK(C4:CC4).
If I add a project at column CD, the formula will still only count to CC. How do I make the formula adjust to the ever increasing amount of columns?
Kind regards
Yannick