Sum Formula Help

[akvpv6]

I am looking for help creating a sum function for my attached spreadsheet. In column G (Total Activity) I would like to show the sum of column D (Quote Count) and column F (Modification Count). However, in the formula I would like it to be crafted so that column G only populates once column D and column F data has been entered, example: if I enter 10 into column D I do not want column G to show 10 while I wait to update column F.

Thank you!

 

[Eric W]

Try:

=IF(COUNT(D2,F2)=2,D2+F2,"")

 

[akvpv6]

Try:

=IF(COUNT(D2,F2)=2,D2+F2,"")

That works, thank you!

 

[Eric W]

Happy to help!

 

[akvpv6]

Happy to help!

actually one further question if you dont mind! how would I alter your formula so that it carries down the entire column? right now it only carries down if I drag it down or use the fill down feature

 

[Eric W]

You can use the G2 formula to spill down the column. Just change the ranges to be larger than the maximum rows you expect. So change the D2:D11 to D2:D1000 for example. I don't recommend using whole column ranges, since that would slow down your sheet. You could try the H2 formula, which figures out how many rows to calculate based on the filled rows in column A.

Book2
	A	B	C	D	E	F	G	H
1	Fiscal Year			Quote Count		Modification Count	Total Activity	Total Activity
2	1			1
3	2					2
4	3			2		3	5	5
5	4			5		3	8	8
6	5
7	6
8	7					6
9	8			2		2	4	4
10	9
11	10			2		3	5	5
12
Sheet7

Cell Formulas
Range	Formula
G2:G11	G2	=IF((D2:D11<>"")*(F2:F11<>""),D2:D11+F2:F11,"")
H2:H11	H2	=LET(c,COUNT(A:A)+1,q,D2:INDEX(D:D,c),m,F2:INDEX(F:F,c),IF((q<>"")*(m<>""),q+m,""))
Dynamic array formulas.