Hi, wondering if someone could help - or at least tell me if something is possible.
I am trying to Return the total number of B's from a range of data, I.e. if the cell above is a B I want it to count the number within the range. Something like this:
<TBODY>
</TBODY><COLGROUP><COL><COL span=8></COLGROUP>
Desired result (without using a pivot table)
<TBODY>
</TBODY><COLGROUP><COL><COL></COLGROUP>
I have tried using a COUNTIF but it aint working... any thoughts?
I am trying to Return the total number of B's from a range of data, I.e. if the cell above is a B I want it to count the number within the range. Something like this:
Data</SPAN> | ||||||||
OPTION</SPAN> | OPTION</SPAN> | OPTION</SPAN> | OPTION</SPAN> | |||||
A</SPAN> | B</SPAN> | A</SPAN> | B</SPAN> | A</SPAN> | B</SPAN> | A</SPAN> | B</SPAN> | |
John</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> | 1</SPAN> |
James</SPAN> | 2</SPAN> | 2</SPAN> | 2</SPAN> | 2</SPAN> | 2</SPAN> | 2</SPAN> | 2</SPAN> | 2</SPAN> |
Ian</SPAN> | 3</SPAN> | 3</SPAN> | 3</SPAN> | 3</SPAN> | 3</SPAN> | 3</SPAN> | 3</SPAN> | 3</SPAN> |
Sue</SPAN> | 4</SPAN> | 4</SPAN> | 4</SPAN> | 4</SPAN> | 4</SPAN> | 4</SPAN> | 4</SPAN> | 4</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL span=8></COLGROUP>
Desired result (without using a pivot table)
Total Bs</SPAN> | |
John</SPAN> | 4</SPAN> |
James</SPAN> | 8</SPAN> |
Ian</SPAN> | 12</SPAN> |
Sue</SPAN> | 16</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL></COLGROUP>
I have tried using a COUNTIF but it aint working... any thoughts?