Only add cell if data in the cell

eechristaylor

Board Regular
Joined
Oct 22, 2013
Messages
51
Office Version
  1. 365
Platform
  1. Windows
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 CostScalabilityAdams-0Adams-1Adams-2Adams-3Adams-4Adams-5
6252022
6002525

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 CostScalabilityAdams-0Adams-1Adams-2Adams-3Adams-4Adams-5
6258787
6038585

How do I write the formula to only add if data in the cell?
 
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
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,919
Members
453,767
Latest member
922aloose

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top