Only add cell if data in the cell

[eechristaylor]

I have a large data set where I am bringing across data by project by county across a state. I use index and match to do this. I want to add additional cells to get a final score with certian conditions but ONLY if the cell has data.

This is what the data looks like across the project using INDEX and Match, the empty cells did not have data.

C column D E F...

Score minus BSL Cost	Scalability	Adams-0	Adams-1	Adams-2	Adams-3	Adams-4	Adams-5
62	5		20	22
60	0		25	25

Another caveat is that Scalability and the number pulled can not be greater than 25, I was going to Use, MIN(D2+(data pulled formula),25)

So here the finished product would be:

C column D E F...

Score minus BSL Cost	Scalability	Adams-0	Adams-1	Adams-2	Adams-3	Adams-4	Adams-5
62	5		87	87
60	3		85	85

How do I write the formula to only add if data in the cell?

 

[Scott Huish]

Not clear why some of the cells changed numbers, where did that data come from?

 

[eechristaylor]

Not clear why some of the cells changed numbers, where did that data come from?

Sorry the scalability change from 0 to 3 was accidental (but in that case it does not matter because the score has already reached the max score of 25)

The change is adding the scalability to the number under the county (max number of 25) and then adding the Score minus BSL Cost, so for

Adams 1 row 1 is 20+5+62
Adams 2 row 1 is 22+5 (which will be 25 since max) +60=85