|There is no built-in formula in Excel that can scan a column, count how many sequential cells meet a given criteria and then return a value based on that count.|
In order to do what you want, you would need to use VBA.
That said, I'm a little confused by your requirements. You mentioned a number of columns that must have certain values in them and then you say "If four cells in a row have data meeting those standards...".
By "four cells in a row" do you mean 4 consecutive cells in a column or any four cells in an Excel row must meet those standards? In other words, "in a row" can mean 2 different things when we're talking about Excel. Which one do you mean?
Let's assume you mean four consecutive cells in a column. Does that mean that the same four cells in every column must meet those standards or are points awarded on a column by column basis or does it mean something else?
What if there are more than 6 cells "in a row" that meet that criteria? Is that still worth 3 points or do we start counting again once we hit 6? Is it "6 or more cells in the row meeting the requirements, that is 3 points" or something else?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.