Thread: Count rows with criteria from two columns?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bert Hyman Bert Hyman is offline
external usenet poster
  
Posts: 2
Default Count rows with criteria from two columns?
In "T. Valko"
wrote:

Try these:

1. In how many rows are either or both cells non-blank.

=SUMPRODUCT(--((A1:A10<"")+(B1:B10<"")0))

2. In how many rows does either or both cells have the value "A"

=SUMPRODUCT(--((A1:A10="A")+(B1:B10="A")0))


That seems to be the answer.

I'll admit that I'm still somewhat baffled by the SUMPRODUCT function,
but maybe now with some personally meaningful data, I can figure it out.

--
Bert Hyman St. Paul, MN
Reply With QuoteReply With Quote