Serie of positive numbers

[drom]

Hi and Thanks in Advance

I have 2 columns, Column("A:A") with employes names sorted always in acending order and Column(B:B") with Totals.

I would like to know if some one has a quik macro to get in Column(B:B) how many times the totals where positive in a row.

So if B2:B12= -52, and B13:B15=45, B17=-5, B18=2, then B1:18 answer is 3 I mean we get 3 cells with positive values in a row, "a serie of 3 positive numbers in a row"

if B2:B18=10 then we get 17

 

[Smitty]

Try COUNTIF:

=COUNTIF(B2:B12,">0")

HTH,

 

[shg]

I read your question a little differently.

=MAX(FREQUENCY(IF(B1:B18>0, ROW(B1:B18)), IF(B1:B18<0, ROW(B1:B18))))

The formul MUST be confirmed with Ctrl+Shift+Enter