ccreations2
New Member
- Joined
- Jul 14, 2013
- Messages
- 2
Hello,
in cells A2:A200 i have dates, than in cells B2:B200 it either "TRUE or FALSE"
im looking for a formula in cell D4 to count how many TRUE cells per month in cell C3
see below how i need it to calculate
<tbody>
</tbody>
i figured out the same idea is sum function as follows but need your help count function
in cell D2 =SUMIFS($B$2:$B$7,$A$2:$A$7,">="&C2,$A$2:$A$7,"<="&EOMONTH(C2,0))
in cell D3 =SUMIFS($B$2:$B$7,$A$2:$A$7,">="&C3,$A$2:$A$7,"<="&EOMONTH(C3,0))
<tbody>
</tbody>
Thank You
in cells A2:A200 i have dates, than in cells B2:B200 it either "TRUE or FALSE"
im looking for a formula in cell D4 to count how many TRUE cells per month in cell C3
see below how i need it to calculate
A | B | C | D | |
1 | Date | Value | Month to count | count |
2 | 1/1/2019 | TRUE | 1/1/2019 | 2 |
3 | 1/15/2019 | TRUE | 2/1/2019 | 1 |
4 | 2/1/2019 | TRUE | 3/1/2019 | 1 |
5 | 2/28/2019 | FALSE | ||
6 | 3/1/2019 | TRUE | ||
7 | 3/31/2019 | FALSE | ||
8 |
<tbody>
</tbody>
i figured out the same idea is sum function as follows but need your help count function
in cell D2 =SUMIFS($B$2:$B$7,$A$2:$A$7,">="&C2,$A$2:$A$7,"<="&EOMONTH(C2,0))
in cell D3 =SUMIFS($B$2:$B$7,$A$2:$A$7,">="&C3,$A$2:$A$7,"<="&EOMONTH(C3,0))
A | B | C | D | |
1 | Date | Value | Month to sum | sum |
2 | 1/1/2019 | 1 | 1/1/2019 | 4 |
3 | 1/15/2019 | 3 | 2/1/2019 | 2 |
4 | 2/1/2019 | 1 | 3/1/2019 | 5 |
5 | 2/28/2019 | 1 | ||
6 | 3/1/2019 | 2 | ||
7 | 3/31/2019 | 3 | ||
8 |
<tbody>
</tbody>
Thank You