CountIf / SumProduct in VB
And again
Sorry Joe
I neglected to increase the range in srcRng to "F4:F300", interestingly the
first cell "M5" had a count value of 177, yet the balance of the cells below
all displayed the correct count.
All the same, I will stick with the nested formula.
Cheers
Mick.
|