Microsoft Microsoft excel 2007 full vers...

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!

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

Excelrow 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 something else?or morecells in the row meeting the requirements, that is 3 points

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History