
excel
根据楼主要的输入,首先需要将度数转换成经度。在
excel中,可以使用SUMPRODUCT函数来实现这个功能。具体来说,可以使用以下公式:=SUMPRODUCT((A1:A1000>90)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A100045)*((A1:A1000