摘要
针对林业统计工作中Excel的应用现状,论述了利用match查询函数检查小班因子数据表中的重号小班,以及利用Sumif条件函数完成统计表并建立该类型表格模型的方法和步骤.对林业统计工作中应用条件函数能提高统计质量及效率等的优点进行了分析.
Focus on the situation of the excel application in forestry statistics, the paper elaborates using match requiring function to check repetitive sub-compartment in data table of sub-compartment factors, finishes statistical table by means of sum if conditional function and explains the method and procedures for setting up such a table model. The paper analyzes the advantages that the application of conditional function in forestry statistics can improve the statistic quality and efficiency.
出处
《林业调查规划》
2010年第2期110-113,共4页
Forest Inventory and Planning