# how to Count cells in column B based on date in column A

#### ccreations2

##### New Member
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

 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

### Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

#### Aryatect

##### Active Member
Hi, you are very close, this should work:

#### Aryatect

##### Active Member
Just another option:

Code:
``=SUMPRODUCT((\$A\$2:\$A\$7 >= C2)*(\$A\$2:\$A\$7 <= EOMONTH(C2,0))*(\$B\$2:\$B\$7=TRUE))``

#### ccreations2

##### New Member
Just another option:

Code:
``=SUMPRODUCT((\$A\$2:\$A\$7 >= C2)*(\$A\$2:\$A\$7 <= EOMONTH(C2,0))*(\$B\$2:\$B\$7=TRUE))``

Thank You, amazing! worked well....
I like the =sumproduct formula better, because im able to count column c as well
just 1 more question Mr Genius can this formula work with count cell with any value? not a specific like true, false, or at specified in the formula?

#### Aryatect

##### Active Member
Hi,

Glad could help! It can work with any value, instead of specifying TRUE or FALSE in a formula you can refer it to any cell, extending your problem where say column B had names and we wanted to find result for specific name then the same formula can be reused as shown below:

1,102,378
Messages
5,486,518
Members
407,550
Latest member
LucasBordure