Hello
I am trying to get a the number of cells that have a value of 1 in each column from the following table
<TBODY>
</TBODY><COLGROUP><COL><COL span=2></COLGROUP>
I have tried using the following formula
COUNTIF((B1:B10,"=1") and (C1:C10,"=1"))
But it is not working. Can you advise what I am doing wrong.
I am trying to get a the number of cells that have a value of 1 in each column from the following table
SR</SPAN> | Email in</SPAN> | Email Out</SPAN> |
1-100000042-7</SPAN> | 1</SPAN> | 1</SPAN> |
1-105414900-7</SPAN> | 1</SPAN> | 1</SPAN> |
1-109295564-7</SPAN> | 1</SPAN> | 1</SPAN> |
1-112045199-7</SPAN> | 1</SPAN> | 1</SPAN> |
1-120700322-7</SPAN> | 1</SPAN> | 1</SPAN> |
1-125862229-7</SPAN> | 1</SPAN> | 1</SPAN> |
1-125970213-7</SPAN> | 1</SPAN> | 1</SPAN> |
1-125998569-7</SPAN> | 1</SPAN> | 1</SPAN> |
1-126474609-7</SPAN> | 1</SPAN> | 1</SPAN> |
1-126768968-7</SPAN> | 1</SPAN> | 1</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL span=2></COLGROUP>
I have tried using the following formula
COUNTIF((B1:B10,"=1") and (C1:C10,"=1"))
But it is not working. Can you advise what I am doing wrong.