ExcelBanter - counta

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - counta (https://www.excelbanter.com/excel-discussion-misc-queries/231668-counta.html)

Graham

counta

I have data in colunm A and would like to count how many there are (in A) if
column (B1:B40)0.

Thanks
gees

Jacob Skaria

counta

=SUMPRODUCT(--(A1:A40<""),--(B1:B400))
--
If this post helps click Yes
---------------
Jacob Skaria

"Graham" wrote:

I have data in colunm A and would like to count how many there are (in A) if
column (B1:B40)0.

Thanks
gees

Graham

counta

Thanks Jacob for such a quicke response...ammazing how technology works!
Formulae works great.

"Jacob Skaria" wrote:

=SUMPRODUCT(--(A1:A40<""),--(B1:B400))
--
If this post helps click Yes
---------------
Jacob Skaria

"Graham" wrote:

I have data in colunm A and would like to count how many there are (in A) if
column (B1:B40)0.

Thanks
gees

All times are GMT +1. The time now is 04:14 AM.