Sum values in a row till blank cell

[GLOJACK]

Hello, hoping someone can help, there have been similar questions for a formula such as this, but I haven't seen it in row form. I am looking to achieve the # in column answer. The rows #'s for the date in which they appear, I only want to count in sequence from the start # i the last cell (9/14) to the last # before the blank cell. Please can anyone assist?

Row Labels	9/8/2020​	9/9/2020​	9/10/2020​	9/11/2020​	9/12/2020​	9/13/2020​	9/14/2020​	ANSWER
A	1​							0
B	1​	1​	2​	1​		1​	1​	2​
C	1​	1​		1​	1​	1​	1​	4​
D				1​	1​	1​		0​
E		1​	1​			1​		0​
F	1​	1​					1​	1​
G	1​	1​	1​		1​	1​	1​	3​
H					1​		1​	1​
I	1​	1​	1​	1​	1​	1​	1​	7​
J						1​		0​
K			1​	1​		1​		0​
L	1​	1​				1​	1​	2​

 

[t0ny84]

If I understand you correctly you want to add all figures in Row A from the column beginning with 9/8/2020 until 9/14/2020?
If that's correct then putting =COUNT(A1:D1) into the Answer column cell of Row A will add all numbers within Row A together.

Just swap A1:D1 to what the cell references are.

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I
1	Row Labels	08/09/2020	09/09/2020	10/09/2020	11/09/2020	12/09/2020	13/09/2020	14/09/2020	ANSWER
2	A	1							0
3	B	1	1	2	1		1	1	2
4	C	1	1		1	1	1	1	4
5	D				1	1	1		0
6	E		1	1			1		0
7	F	1	1					1	1
8	G	1	1	1		1	1	1	3
9	H					1		1	1
10	I	1	1	1	1	1	1	1	7
11	J						1		0
12	K			1	1		1		0
13	L	1	1				1	1	2
14
Main

Cell Formulas
Range	Formula
I2:I13	I2	=COLUMNS(A2:H2)-IFERROR(LOOKUP(2,1/(B2:H2=""),COLUMN(B2:H2)),1)

 

[GLOJACK]

If I understand you correctly you want to add all figures in Row A from the column beginning with 9/8/2020 until 9/14/2020?
If that's correct then putting =COUNT(A1:D1) into the Answer column cell of Row A will add all numbers within Row A together.

Just swap A1:D1 to what the cell references are.

Thank you Tony, I think you are saying to give a total count, but I just want it to count if there is a # in the most recent date

 

[GLOJACK]

Hi & welcome to MrExcel.
How about...

Fluff thank you so much for your help , this worked perfectly !

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[GLOJACK]

Glad we could help & thanks for the feedback.

Please can you help me again. The data set is pulling from a pivot table, and when a new column is added the formula will only stop to last cell example below

So I changed the formula to pull more columns so it can recalculate max columns with data, but then it changes the formula to zero

Anyway to change it so it can recalculate to the last cell with data?

 

[Fluff]

Does your data go all the way to ZZ?

 

[GLOJACK]

Does your data go all the way to ZZ?

No, a new column is added each day, I just wanted to make it easier and go to a column far out

 

[Fluff]

In that case how would the formula know which cell to start counting in?
You wanted a formula that would return 0 if the last column was blank, which is what it does.