ExcelBanter - count for multiple conditions in multiple columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - count for multiple conditions in multiple columns (https://www.excelbanter.com/excel-worksheet-functions/236250-count-multiple-conditions-multiple-columns.html)

tturklsu

count for multiple conditions in multiple columns

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?

Teethless mama

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?

David Biddulph[_2_]

count for multiple conditions in multiple columns

=SUMPRODUCT((A1:A100<0)*(B1:B100<0))
--
David Biddulph

"tturklsu" wrote in message
...

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?

All times are GMT +1. The time now is 03:10 AM.