I'm trying to come up with a count formula to meet my needs.
I want the formula to count each row in a sheet that meets two requirements.
Here is an example of how the table looks:
<tbody>
</tbody>
I have this formula for counting how many rows fall in a specific month:
And I have this formula for counting how many rows contain a specific text (Level)
I need to combine them somehow. Not sure if it is possible to combine these two exact methods but I need something that lets me count the rows that are of a specific month and of a specific level.
Thanks for any help everyone.
I want the formula to count each row in a sheet that meets two requirements.
- A cell in a certain column contains a specific text.
- A cell in a certain column falls within a specific month, the cell is currently in the mm/dd/yyyy format.
Here is an example of how the table looks:
Title | Level | Date |
Water | Critical | 1/2/13 |
Power | High | 1/15/13 |
Power | High | 1/15/13 |
Filter | Low | 1/30/13 |
Heat | High | 2/5/13 |
Ducts | Low | 2/15/13 |
Lock | Low | 2/15/13 |
Window | Low | 2/15/13 |
<tbody>
</tbody>
I have this formula for counting how many rows fall in a specific month:
Code:
=SUMPRODUCT(--(C$2:C$1048576<>""),--(MONTH(C$2:C$1048576)=1))
And I have this formula for counting how many rows contain a specific text (Level)
Code:
=COUNTIF(B2:B1048576, "High")
I need to combine them somehow. Not sure if it is possible to combine these two exact methods but I need something that lets me count the rows that are of a specific month and of a specific level.
Thanks for any help everyone.