Sumifs+index formula help!!

[WormJacob]

Hello ,

NEw to this forum and would to get help(first thank you in advanced)!!

I need help to create a formula that sum the following Summary below?

[TABLE="width: 1023"]
<colgroup><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[kvsrinivasamurthy]

Second Table starts From B14.
Months NAME in C15,E15,G15 is to be replaced by 1/1/18,1/2/18,1/3/18 (dd/mm/yy)
B16=Fruits

Formula in C17, then drag across

=SUMPRODUCT(($F$2:$M$7)*((($A$2:$A$7=$B17)*($D$2:$D$7=C$16))*(MONTH($F$1:$M$1)=MONTH(INDEX($C$15:$H$15,IF(ISODD(COLUMNS($C$15:C$15)),COLUMNS($C$15:C$15),COLUMNS($C$15:C$15)-1))))))

 

[Eric W]

Similar in concept:

	A	B	C	D	E	F	G	H	I	J	K	L	M
Part	Part Description	Lead-time	Order Type	50 wk Total
Apple	Whole	PO
Apple	Whole	Planned
Banana	Whole	PO
Pears	Whole	Planned
Pears	Whole	Planned
Orange	Whole	PO
Jan	Feb	Mar
Fruits	Planned	PO	Planned	PO	Planned	PO
Apple
Banana
Pears
Orange

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]12/25/2017[/TD]
[TD="align: right"]1/1/2018[/TD]
[TD="align: right"]1/8/2018[/TD]
[TD="align: right"]1/29/2018[/TD]
[TD="align: right"]2/5/2018[/TD]
[TD="align: right"]2/12/2018[/TD]
[TD="align: right"]2/26/2018[/TD]
[TD="align: right"]3/5/2018[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]3[/TD]

[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]3[/TD]

[TD="align: right"]740[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]20[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]5[/TD]

[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]5[/TD]

[TD="align: right"]720[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]15[/TD]

[TD="align: right"]740[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]20[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]15[/TD]

[TD="align: right"]26[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"]2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]

[TD="align: right"]40[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]

[TD="align: right"]20[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]140[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]

[TD="align: right"]0[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B14[/TH]
[TD="align: left"]=SUMPRODUCT(($F$2:$M$7)*($D$2:$D$7=B$13)*(YEAR($F$1:$M$1)=$B$11)*(TEXT($F$1:$M$1,"mmm")=INDEX($B$12:$G$12,COLUMNS($B2:B2)-MOD(COLUMN(),2)))*($A$2:$A$7=$A14))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



The layout of your tables made it a bit tricky. I assume you'd put the result table on another sheet. The year and months are probably merged cells. Put the formula in B14, drag down and across as needed.

 

[WormJacob]

Thanks ERIC!! Really appreciated.!!!!! Quite honest that table are sooo tricky and this is how i received from my customer and im trying to Simplified it instead of manual modifying it each time.. Again.. Thanks for the support

 

[Eric W]

Glad to help!

 

[WormJacob]

Hi Eric/Anyone?

Formula work on same sheet.. When i created Summary on NEW Sheet(refer sheet and ranges )

Here is new Formula: It came out #n/A and 0 on the rest of the column?

This is the Summary(Summary)

Forecast0109(data)

 

[Eric W]

Try:

	A	B	C	D	E	F	G	H
Jan	Feb	Mar
Part	Planned	PO	Planned	PO	Planned	PO
Apple
Banana
Pears
Orange

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"][/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]140[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]0[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

</tbody>

Summary​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C4[/TH]
[TD="align: left"]=SUMPRODUCT((Forecast!$I$2:$P$7)*(Forecast!$G$2:$G$7=C$3)*(YEAR(Forecast!$I$1:$P$1)=$C$1)*(TEXT(Forecast!$I$1:$P$1,"mmm")=INDEX($C$2:$H$2,FLOOR(COLUMNS($C2:C2)-1,2)+1))*(Forecast!$A$2:$A$7=$A4))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



I changed the formula to use FLOOR instead of MOD, which should eliminate one type of problem when you insert columns. Other things to look for is I have my Months in C2,E2,G2, and you have them in D2,F2, and H2. Also, F2 is a date, not a month abbreviation. If you want to Merge and Center C2:D2 (and the rest of the months), then it looks better and the formula works. Also, I can adapt it to use either the 3-letter abbreviation, or the first of the month as a date if you want.

Also, consider using a tool like the HTML Maker in my signature. It makes it much easier for someone to copy your data to work with. Your screen prints are good, but many people won't spend the time to type in a large table. That's why I used the old data, but I moved it to your new ranges.

 

[WormJacob]

Thank Eric.. I will try this.. I will them on HTMl maker if any thing wrongs comes up (on my side)! Thank you

 

[WormJacob]

Hi Eric/Someone?

Sorry i couldn't load on HTML. 2 sheet (1tab- Summary) & (2nd FRC-Jan18 data) .. Not error but just not calculating ... All are ZERO


Summary
[TABLE="width: 466"]
<colgroup><col><col><col span="6"></colgroup><tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD] [/TD]
[TD]2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Months[/TD]
[TD="colspan: 2"]Jan[/TD]
[TD="colspan: 2"]Feb[/TD]
[TD="colspan: 2"]Mar[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Part[/TD]
[TD]Planned[/TD]
[TD]PO[/TD]
[TD]Planned[/TD]
[TD]PO[/TD]
[TD]Planned[/TD]
[TD]PO[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]1647670[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]2104179[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]3118228[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]3118237[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 1368"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Cell[/TD]
[TD]Formula[/TD]
[/TR]
[TR]
[TD]C4[/TD]
[TD]=SUMPRODUCT(('FRC-Jan18'!$E$2:$BB$103)*('FRC-Jan18'!$C$2:$C$103=AA$3)*(YEAR('FRC-Jan18'!$E$1:$BB$1)=$C$1)*(TEXT('FRC-Jan18'!$E$1:$BB$1,"mmm")=INDEX($C$2:$Y$2,FLOOR(COLUMNS($C2:AA2)*1,2)+1))*('FRC-Jan18'!$A$2:$A$103=$A4))[/TD]
[/TR]
</tbody>[/TABLE]

FRC-Jan18

[TABLE="width: 700"]
<colgroup><col><col span="3"><col><col><col span="3"><col><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Part[/TD]
[TD]Part Description[/TD]
[TD]Order Type[/TD]
[TD]50 wk Total[/TD]
[TD="align: right"]1/8/2018[/TD]
[TD="align: right"]1/15/2018[/TD]
[TD="align: right"]1/22/2018[/TD]
[TD="align: right"]1/29/2018[/TD]
[TD="align: right"]2/5/2018[/TD]
[TD="align: right"]2/12/2018[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]3951894[/TD]
[TD]Whole[/TD]
[TD]Planned [/TD]
[TD="align: right"]294[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]3951894[/TD]
[TD]Whole[/TD]
[TD]Planned [/TD]
[TD="align: right"]504[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]4851751[/TD]
[TD]Whole[/TD]
[TD]No Orders[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]3305442[/TD]
[TD]Whole[/TD]
[TD]No Orders[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]3305524[/TD]
[TD]Whole[/TD]
[TD]Planned [/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]4109268[/TD]
[TD]Whole[/TD]
[TD]Planned [/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]4142630[/TD]
[TD]Whole[/TD]
[TD]Planned [/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]4142630[/TD]
[TD]Whole[/TD]
[TD]PO [/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]4157695[/TD]
[TD]Whole[/TD]
[TD]PO [/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]4157695[/TD]
[TD]Whole[/TD]
[TD]Planned [/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

Thank you again in advance!
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>

 

[Eric W]

You missed changing one range reference, and had another typo. Try:

C4:

=SUMPRODUCT(('FRC-Jan18'!$E$2:$BB$103)*('FRC-Jan18'!$C$2:$C$103=C$3)*(YEAR('FRC-Jan18'!$E$1:$BB$1)=$C$1)*(TEXT('FRC-Jan18'!$E$1:$BB$1,"mmm")=INDEX($C$2:$Y$2,FLOOR(COLUMNS($C2:C2)-1,2)+1))*('FRC-Jan18'!$A$2:$A$103=$A4))