eechristaylor
Board Regular
- Joined
- Oct 22, 2013
- Messages
- 51
- Office Version
- 365
- Platform
- 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...
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...
How do I write the formula to only add if data in the cell?
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?