Need an array formula for Counting the no. of positive numbers in a col
From San@21:1/5 to All on Thu Apr 27 21:54:54 2023
Hi
I have a 2-column data as follows
Col A Col B
Wed 38
Mon -5
Tue 11
Wed 91
Sat -31
Mon -7
Fri 66
... And so on and so forth.
Filters are applied to both columns.
In Column C, I would like to have a formula that counts how many positive numbers are in Column B for any selection done in Column A by filter. For eg. If i filter "Mon" in Column A, Column C will give a Count of Zero. Similarly If I filter "Wed"
in Column A , Column C will give a count of 2.
I tried to use Countif but it is taking into account the whole range in Column B.