Only add a group of cells if data exists in a cell

[eechristaylor]

I have a data sorce where I bring a number across using INDEX and Match to bring across the data.

Data source

A	B	C	D	E
project	Adams-1	Adams-2	Adams-3	Adams-4
1234	25	12	21
5678		25	15

Where I need to add data:

A	B	C	D	E	F	G
project	Score total	Feasibility Score	Adams-1	Adams-2	Admas-3	Adams-4
1234	62	5	25+62+5=92	12+5+62=79	(21+5)(max 25) +62=87
5678	64	5		25+64=89	15+5+64=84

So if the data pulled is not there, i.e. project 5678 for Adams-1, there does not need to be any addition.
For the cells with data we will add the Data source to the Feasibility Score first and max here can only be 25 (i was going to use MIN(C2+D2,25) as this is reflected across project 1234 for Adams-3.

Any help on how this formula look to not add when there is no data would be appreciated.

 

[StephenCrump]

How about?

	A	B	C	D	E	F	G
1	project	Adams-1	Adams-2	Adams-3	Adams-4
2	1234	25	12	21
3	5678		25	15
4
5
6
7	project	Score total	Feasibility Score	Adams-1	Adams-2	Admas-3	Adams-4
8	1234	62	5	92	79	87	??
9	5678	64	5		94	84	??
10
Sheet1

Cell Formulas
Range	Formula
D8:E9	D8	=IF(B2="","",SUM($B8:$C8)+B2)
F8:F9	F8	=IF(D2="","",MIN(25,D2+C8)+B8)

I have assumed the projects in the two tables correspond one-to-one, i.e. no need to lookup the correct row.

The value highlighted is different to your number - perhaps you have a typo in your calculation, omitting the +5?

 

[eechristaylor]

How about?

	A	B	C	D	E	F	G
1	project	Adams-1	Adams-2	Adams-3	Adams-4
2	1234	25	12	21
3	5678		25	15
4
5
6
7	project	Score total	Feasibility Score	Adams-1	Adams-2	Admas-3	Adams-4
8	1234	62	5	92	79	87	??
9	5678	64	5		94	84	??
10
Sheet1

Cell Formulas
Range	Formula
D8:E9	D8	=IF(B2="","",SUM($B8:$C8)+B2)
F8:F9	F8	=IF(D2="","",MIN(25,D2+C8)+B8)

I have assumed the projects in the two tables correspond one-to-one, i.e. no need to lookup the correct row.

The value highlighted is different to your number - perhaps you have a typo in your calculation, omitting the +5?

I omitted the +5 due to the cell already at the max of 25. I need the same formula across all cells as there are 1300 columns across 300 rows (projects)

 

[StephenCrump]

I omitted the +5 due to the cell already at the max of 25. I need the same formula across all cells as there are 1300 columns across 300 rows (projects)

In that case:

D8: =IF(B2="","",MIN(25,B2+$C8)+$B8)

(The calculation you showed for D8 didn't include the 25 cap)