Calculate Points in Excel

Microsoft Microsoft excel 2007 full vers...
August 2, 2011 at 20:31:16
Specs: Windows 7
I am trying to come up with a formula in Excel that will calculate point values. Here is my scenario:

I have two columns that the data inputed needs to be greater than or equal to 15 to count. Additionally, every other column has to have data greater than or equal to 3.

If four cells in a row have data meeting those standards, that equals 1 point, if five cells in the row have data meeting the requirements, it equals 2 points, and if there are 6 cells in the row meeting the requirements, that is 3 points.

Hopefully you understand what I am trying to do. Please help!

See More: Calculate Points in Excel

Report •

August 3, 2011 at 11:56:35
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.

Report •
Related Solutions

Ask Question