Thread: count for multiple conditions in multiple columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default count for multiple conditions in multiple columns
XL-2007
=COUNTIFS(A1:A10,"<0",B1:B10,"<0")

All versions
=SUMPRODUCT(--(A1:A10<0),--(B1:B10<0))



"tturklsu" wrote:

I have two columns of numbers and i want to count how many times both columns
have a nonzero number on the same row. What is the formula to do this?
Reply With QuoteReply With Quote