View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Count NonBlank Rows with Criteria in another column

Thanks!

--
Biff
Microsoft Excel MVP


"smartin" wrote in message
...
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.