从多个Excel工作表中提取数据并计算特定项目 [英] Pull data from multiple Excel sheets and count specific items

问题描述

我有一个问题，我认为答案应该是相当简单的，但我无法理解。

我们有一个Excel电子表格，我们跟踪线索。我的老板想知道，具体来说每个月有多少线索，每个来源和结果有多少。

我想把公式放在一个单独的表格在同一本书中意思是，我需要一个公式，从另一张表格中的指定范围的单元格中提取数据，并计算在特定月份（12012或22012）中有多少潜在客户。

$ b $我尝试过以下变体：
='Sheet1'！（= COUNTIF（e2：e20，12012））
='Sheet1'！counte2：e20
和sum函数，vlookup，以及基本上每个其他的编程答案，我可以在多个论坛上遇到问题甚至远离我正在努力做的事情。

我认为问题是从不同的表单中拉出来，但是我无法弄清楚如何使我的公式正常运行。

所有将不胜感激

解决方案

= COUNTIF（Sheet1！A14：A21,12012）

I have a question and I think the answer should be fairly simple, but I cannot get it figured out.

We have an Excel spreadsheet where we track out leads. My boss wants to know, specifically "how many leads for each month and how many of each source and the result."

I want to put the formula in a separate sheet in the same workbook; meaning, I need a formula that pulls the data from a specified range of cells in a different sheet, and counts how many leads we had in a specific month (12012, or 22012).

I've tried variations of the following: ='Sheet1'!(=COUNTIF(e2:e20,"12012")) ='Sheet1'!counte2:e20 and the sum function, vlookup, and basically every other programming answer I could come across on multiple forums where the question was even remotely close to what I am trying to do...

I think the problem is getting it to pull from the different sheet, but I can't figure out how to make my formula work correctly.

Any help at all would be appreciated.

解决方案

=COUNTIF(Sheet1!A14:A21,12012)

这篇关于从多个Excel工作表中提取数据并计算特定项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！