Count NonBlank Rows with Criteria in another column
T. Valko wrote:
I'm assuming you want to count a row if there is at least one entry in that
row.
=SUMPRODUCT(--(MMULT(--(K3:N35<""),{1;1;1;1})0),--(O3:O35="A"))
Nice solution Biff! And thanks for writing about MMULT... this was
unknown to me, and I suspect many others as well.
|