格:B7
{=SUM((IF('[Sales Record.xls]7th'!$B$14:$CZ$14<>"y",IF('[Sales Record.xls]7th'!$B$19:$CZ$19=1,'[Sales Record.xls]7th'!$B$38:$CZ$38))))}
格:B8
=SUM((IF('[Sales Record.xls]8th'!$B$14:$CZ$14<>"y",IF('[Sales Record.xls]8th'!$B$19:$CZ$19=1,'[Sales Record.xls]8th'!$B$38:$CZ$38))))
我見到係有唔同,係因為符號{ },請問點好?因為依家B8出唔到我想要嘅數,請幫忙!
many thanks~~~
更新1:
請問咩係「列陣公式」?