Pull data from multiple Excel sheets and count spe

Question

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.

Answer 1

=COUNTIF(Sheet1!A14:A21,12012)