View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default Creating Nested Functions

T. Valko wrote...
That's the same as:

=COUNTIF(A1:A10,C1)+COUNTIF(B1:B10,D1)

The OP wanted the count where both criteria are on the same row.

....

You're right. It'd need to be something like

=COUNT(1/(MMULT(--(A1:B10=C1:D1),{1;1})=2))

but nothing gained with just two sets of comparisons.