Excel Formula help to count rows once a value occurs but not when a second value occurs

[deharris]

I could use a hand here on what I think is a sumproduct need. I have a table where I'm only interested in counting the row when a value occurs for the first time. See the top row of the picture here for the formula solution needed. The end goal is to get a running total of the number or rows that has a value each day but only until the first value occurs. Once that first value occurs, there's no need to add additional values. I appreciate any help.
thank you

picture link

https://www.dropbox.com/s/0x57jnfsmias4vg/Picture2.jpg?dl=0

 

[sheetspread]

Try =median(sum(myrange),0,1)

or

--(SUM(myrange)>0)

 

[deharris]

Thank you for the reply. Each of the formulas only returns a 1 at the top of the column where an entry is recorded after a blank column. I'm looking to capture the total new/unique/first time entries in that column moving left to right on the example I shared.
thank you again,

 

[sheetspread]

This?

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		1/1/2018	1/2/2018	1/3/2018	1/4/2018	1/5/2018	1/6/2018	1/7/2018	1/8/2018	1/9/2018	1/10/2018	1/11/2018	1/12/2018
2	Customer 1								8			8		1
3	Customer 2					3							3	1
4	Customer 3													0
5	Customer 4					10						20	20	2
Sheet1

Cell Formulas
Range	Formula
N2	=SUMPRODUCT(($B2:$M2<>"")/COUNTIF($B2:$M2,$B2:$M2&""))

 

[deharris]

The formula provided appears to show me the number of unique occurrences in each row, not the top row of the photo link provided for the number of first time occurrences each day by row (customer). In the photo link, I'm trying to solve for the top row and the duplicate entries (highlighted in yellow and regardless of value) wouldn't be counted by the formula. Your Sumproduct is close and is actually a huge help for me on another project so thank you!

 

[sheetspread]

I'm trying to solve for the top row and the duplicate entries (highlighted in yellow and regardless of value) wouldn't be counted by the formula.

I wouldn't just write a formula for this, instead unpivot the data with

https://www.youtube.com/watch?v=xmqTN0X-AgY

then add a column with this formula: =IF(C2="",0,IF(COUNTIFS($A$2:A2,A2,$C$2:C2,">0")=1,1,0))

and set two pivot tables one above the other:

 

[sheetspread]

A helper column will also work with the original format if you must keep it:

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		0	1	3	5	8	0	1	2	1	2	4	1
2		1/1/2018	1/2/2018	1/3/2018	1/4/2018	1/5/2018	1/6/2018	1/7/2018	1/8/2018	1/9/2018	1/10/2018	1/11/2018	1/12/2018
3	Customer 1								8.00			8.00		8
4	Customer 2					3.00							3.00	5
5	Customer 3													0
6	Customer 4					10.00					20.00	20.00		5
7	Customer 5											14.00		11
8	Customer 6							14.00				14.00		7
9	Customer 7					21.00								5
10	Customer 8					2.00							6.00	5
11	Customer 9			9.00					9.00					3
12	Customer 10											32.00		11
13	Customer 11										10.00			10
14	Customer 12				2.00									4
15	Customer 13			3.00							3.00			3
16	Customer 14													0
17	Customer 15									16.00			27.00	9
18	Customer 16				4.00					4.00				4
19	Customer 17											3.00		11
20	Customer 18										3.00			10
21	Customer 19				12.00							3.00		4
22	Customer 20				3.00									4
23	Customer 21								2.50					8
24	Customer 22					2.00							2.00	5
25	Customer 23				2.50					2.50				4
26	Customer 24					2.00								5
27	Customer 25		2.00											2
28	Customer 26					3.00						2.50		5
29	Customer 27					12.00					12.00			5
30	Customer 28											3.00		11
31	Customer 29												3.00	12
32	Customer 30			1.00							2.00			3
Sheet1 (2)

Cell Formulas
Range	Formula
B1	=COUNTIF($N$3:$N$32,COLUMN()-1)
N3	{=IFERROR(MATCH(TRUE,$B3:$M3<>"",0),0)}
Press CTRL+SHIFT+ENTER to enter array formulas.