Golf Score If Blank or Zero

[Gulfcourse]

Hello again,

I'm struggling with a formula and could use help!

I have two Excel golf files, long story, and use one for almost everything in the league, I'll refer to it as (1), the other I'll refer to as (2), just to calculate skins using handicaps.
I'm bringing in values from (1) into (2), for example into cell F74, using ; ='[GMGOLF_2025.xlsx]18-hole scores'!D26
The problem is, even though the cells in sheet (1) are blank it is putting 0's into (2) F74 and the others.
This is causing an issue with highest handicap golfer getting skins even though he did not play!

I would like the cell in (2) to be BLANK if the cell in (1) is BLANK.

In (2) F74 there is a 0 even though D26 in (1) was blank.
In the next row used in (2) F76 it calculates Gross Total using
=IF(SUMPRODUCT(F74:F75)=0,"",SUMPRODUCT(F74:F75))
In the next row used in (2) F79 it calculates Net Total using
=IF(SUM(F77:F78)=0,"",SUM(F77:F78)) this is where I'm getting -1 for highest handicap golfer

I tried to figure this out but do not know where to put the =IF(ISBLANK(cell_reference), "", cell_reference) formula.
Could I put it into ='[GMGOLF_2025.xlsx]18-hole scores'!D26 or somewhere else?

I didn't think I'd have to load both into Xl2bb but will if it helps!

Thank you so much.

 

[St Jimmy]

I'd try putting the "IF(IsBlank(cell_reference), "", cell_reference) formula into the receiving cell in (2) that is pulling the blanks as a -1.
The idea is this formula is pre-processing the input and ignoring blanks before it tries to calculate a result.

Can you show a snippet of worksheet?

 

[Fluff]

How about

=let(a,'[GMGOLF_2025.xlsx]18-hole scores'!D26,if(a="","",a))

 

[Gulfcourse]

I'd try putting the "IF(IsBlank(cell_reference), "", cell_reference) formula into the receiving cell in (2) that is pulling the blanks as a -1.
The idea is this formula is pre-processing the input and ignoring blanks before it tries to calculate a result.

Can you show a snippet of worksheet?

Formulas in (2)
F74 ='[Book1]18-hole scores'!D26
F76 =IF(SUMPRODUCT(F74:F75)=0,"",SUMPRODUCT(F74:F75))
F79 =IF(SUM(F77:F78)=0,"",SUM(F77:F78))

I reaaly appreciate the help but part of my ignorance is understanding where exactly to put the If isblank into the equation.
I tried to do the xl2bb in (2) but kept getting a message: the following named range elements are not properly set therefore they are excluded
Scorecards!_FilterDatabase: $A$1:$B$1053
It said it copied something though????

Copy of Individual or Team Skins Game Results(SPECIAL-2023-11-09).xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
74	Lincoln		Gold	17	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0	0	0	0	0	0
76	Lincoln	Gross Tot												0											0	0
79	Lincoln	Net Tot			-1	-1	-1	-1	-1	-1	-1	-1	-1	-9		-1	-1	-1	-1	-1	-1	-1		-1	-8	-17
ScoreCards

Cell Formulas
Range	Formula
B74	B74	='[GMGOLF_2025.xlsx]18-hole scores'!$B$26
C74	C74	=IFERROR(IF($B74="","",INDEX('C:\Users\prje1\Temp\Golf Tournaments Testing\Folder to use for Distribution Setup\[SharedScorecard.xlsx]ScoreCards'!$A$4:$X$200,MATCH($B74,'C:\Users\prje1\Temp\Golf Tournaments Testing\Folder to use for Distribution Setup\[SharedScorecard.xlsx]ScoreCards'!$A$4:$A$200,0),BE$3)),"")
D74	D74	=IFERROR(IF($B74="","",INDEX('C:\Users\prje1\Temp\Golf Tournaments Testing\Folder to use for Distribution Setup\[SharedScorecard.xlsx]ScoreCards'!$A$4:$X$200,MATCH($B74,'C:\Users\prje1\Temp\Golf Tournaments Testing\Folder to use for Distribution Setup\[SharedScorecard.xlsx]ScoreCards'!$A$4:$A$200,0),BF$3)),INDEX(CourseSetup!$Y$4:$AB$11,MATCH("Y",CourseSetup!$AB$4:$AB$11,0),1))
E74	E74	=ROUND([GMGOLF_2025.xlsx]RESULTS!$H$13,0)
F74:N74	F74	='[GMGOLF_2025.xlsx]18-hole scores'!D26
O74,O76,O79,Z74,Z76,Z79	O74	=SUM(F74:N74)
F76:N76,Q76:Y76	F76	=IF(SUMPRODUCT(F74:F75)=0,"",SUMPRODUCT(F74:F75))
F79:N79,Q79:Y79	F79	=IF(SUM(F77:F78)=0,"",SUM(F77:F78))
Q74:Y74	Q74	='[GMGOLF_2025.xlsx]18-hole scores'!N26
AA74,AA76,AA79	AA74	=Z74+O74
B76	B76	=IF(AND(B74="",B75=""),"",IF(B75="",B74,B74&"-"&B75))
B79	B79	=IF(AND(B74="",B75=""),"",IF(B75="",B74,B74&"-"&B75))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
Q11:Y12,Q18:Y19,Q25:Y26,Q32:Y33,Q39:Y40,Q46:Y47,Q53:Y54,Q60:Y61,Q67:Y68,Q74:Y75,Q81:Y82,Q88:Y89,Q95:Y96,Q102:Y103,Q109:Y110,Q116:Y117,Q123:Y124,Q130:Y131,Q137:Y138,Q144:Y145,Q151:Y152,Q158:Y159,Q165:Y166,Q172:Y173,Q179:Y180,Q186:Y187,Q193:Y194,Q200:Y201	Expression	=ISFORMULA(Q11)	text	NO
F11:N12,F18:N19,F25:N26,F32:N33,F39:N40,F46:N47,F53:N54,F60:N61,F67:N68,F74:N75,F81:N82,F88:N89,F95:N96,F102:N103,F109:N110,F116:N117,F123:N124,F130:N131,F137:N138,F144:N145,F151:N152,F158:N159,F165:N166,F172:N173,F179:N180,F186:N187,F193:N194,F200:N201	Expression	=ISFORMULA(F11)	text	NO
D11:D12,D18:D19,D25:D26,D32:D33,D39:D40,D46:D47,D53:D54,D60:D61,D67:D68,D74:D75,D81:D82,D88:D89,D95:D96,D102:D103,D109:D110,D116:D117,D123:D124,D130:D131,D137:D138,D144:D145,D151:D152,D158:D159,D165:D166,D172:D173,D179:D180,D186:D187,D193:D194,D200:D201	Expression	=OR(CG11="not linked",NOT(ISFORMULA(D11)))	text	NO
C11:C12,C18:C19,C25:C26,C32:C33,C39:C40,C46:C47,C53:C54,C60:C61,C67:C68,C74:C75,C81:C82,C88:C89,C95:C96,C102:C103,C109:C110,C116:C117,C123:C124,C130:C131,C137:C138,C144:C145,C151:C152,C158:C159,C165:C166,C172:C173,C179:C180,C186:C187,C193:C194,C200:C201	Expression	=ISFORMULA(C11)	text	NO
F13:N13,P13:Y13,F20:N20,P20:Y20,F27:N27,P27:Y27,F34:N34,P34:Y34,F41:N41,P41:Y41,F48:N48,P48:Y48,F55:N55,P55:Y55,F62:N62,P62:Y62,F69:N69,P69:Y69,F76:N76,P76:Y76,F83:N83,P83:Y83,F90:N90,P90:Y90,F97:N97,P97:Y97,F104:N104,P104:Y104,F111:N111,P111:Y111,F118:N118	Expression	=F13<SMALL(AW$6:AW$1053,2)	text	NO
F16:N16,P16:Y16,F23:N23,P23:Y23,F30:N30,P30:Y30,F37:N37,P37:Y37,F44:N44,P44:Y44,F51:N51,P51:Y51,F58:N58,P58:Y58,F65:N65,P65:Y65,F72:N72,P72:Y72,F79:N79,P79:Y79,F86:N86,P86:Y86,F93:N93,P93:Y93,F100:N100,P100:Y100,F107:N107,P107:Y107,F114:N114,P114:Y114	Expression	=F16<SMALL(AC$9:AC$1053,2)	text	NO

Cells with Data Validation
Cell	Allow	Criteria
B74:B75	List	=OFFSET($CF$4:$CF$1153,0,0,1150-COUNTBLANK($CF$4:$CF$1153),1)
C74:C75	Custom	=OR(C74="",C74="CS",AND(C74>=-9.9,C74<=54))
D74:D75	List	=CourseSetup!$Y$4:$Y$11

 

[Gulfcourse]

I got it using: =IF(ISBLANK('[GMGOLF_2025.xlsx]18-hole scores'!N42),"",('[GMGOLF_2025.xlsx]18-hole scores'!N42))
and copying the formula throughout the sheet! Thank you!

 

[Peter_SSs]

I got it using: =IF(ISBLANK('[GMGOLF_2025.xlsx]18-hole scores'!N42),"",('[GMGOLF_2025.xlsx]18-hole scores'!N42))
and copying the formula throughout the sheet! Thank you!

Does that mean you didn't try the much simpler formula structure in post #3?
.. or you just prefer the longer form?

 

[Gulfcourse]

LOL, it means I'm not that bright!

 

[Peter_SSs]

LOL, it means I'm not that bright!

It seems the values being brought from the other workbook are numerical or blanks. If that is so then another option would be

=IFERROR(--('[GMGOLF_2025.xlsx]18-hole scores'!N42&""),"")

 

[Gulfcourse]

It seems the values being brought from the other workbook are numerical or blanks. If that is so then another option would be

=IFERROR(--('[GMGOLF_2025.xlsx]18-hole scores'!N42&""),"")

Thank you Peter, I pasted it in but 2 rows downs, in Net Total, when there was a score put in N42 in 18-hole scores, it returned #VALUE in the skins sheet!
I'll play around a little more with it, so I know it will work by the time our season starts.

 

[KevCarter]

Thank you Peter, I pasted it in but 2 rows downs, in Net Total, when there was a score put in N42 in 18-hole scores, it returned #VALUE in the skins sheet!
I'll play around a little more with it, so I know it will work by the time our season starts.

GulfCourse, I use this type of system for skins as well. Circling back to Fluff's post with a slight change, here is what works for me;

=let(NetScore,'[GMGOLF_2025.xlsx]18-hole scores'!N42,if(NetScore=0,"",NetScore))