=SUMIF(钢板信息!$B$3:$B$10000,B3,钢板信息!$F$3:$F$10000)

这个公式是用来计算一个范围内满足特定条件的单元格的和。具体来说，它会在"钢板信息"工作表的B3:B10000范围内查找与当前单元格B3相匹配的值，并将对应的F列的值相加。\[3\]这个公式可以用来统计钢板信息工作表中特定钢板的总和。
#### 引用[.reference_title]
- *1* *3* [Vlookup函数最经典的14种用法（转自：Excel精英培训）](https://blog.csdn.net/weixin_42392800/article/details/108399118)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* [[Excel函数] SUM函数 | SUMIF函数 | SUMIFS函数](https://blog.csdn.net/Hudas/article/details/124239429)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]