PCloadletter
New Member
- Joined
- May 14, 2020
- Messages
- 15
- Office Version
- 365
- 2016
- 2010
- Platform
- Windows
Hello,
I am trying to find a formula to count across all worksheets with two specific criteria. Summary of what I have:
1) My spreadsheet has 14 sheets (12 being January to December, 1 being Stats and the last one Sheet1)
2) Sheet1 has January to December in A1 to A12 and is named "Months"
3) I want to be able to place in my Stats worksheet, the total count from two criteria in each sheet. My stats worksheet has a list of sites through column A.
Column H in my January to December sheets is for sites
Column I will have "Monthly Pass" for example
I need to find out how many times Monthly pass occurs with any site.
For example, I want to know that Mountain View has 256 monthly passes over the 12 worksheets.
Thank you in advance.
I am trying to find a formula to count across all worksheets with two specific criteria. Summary of what I have:
1) My spreadsheet has 14 sheets (12 being January to December, 1 being Stats and the last one Sheet1)
2) Sheet1 has January to December in A1 to A12 and is named "Months"
3) I want to be able to place in my Stats worksheet, the total count from two criteria in each sheet. My stats worksheet has a list of sites through column A.
Column H in my January to December sheets is for sites
Column I will have "Monthly Pass" for example
I need to find out how many times Monthly pass occurs with any site.
For example, I want to know that Mountain View has 256 monthly passes over the 12 worksheets.
Thank you in advance.