ExcelBanter - how do I count the sum of 2 columns in excel? countif(a1:a100='op.

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

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

- - how do I count the sum of 2 columns in excel? countif(a1:a100='op. (https://www.excelbanter.com/excel-worksheet-functions/14234-how-do-i-count-sum-2-columns-excel-countif-a1-a100%3Dop.html)

Bruce

how do I count the sum of 2 columns in excel? countif(a1:a100='op.

I am having trouble with the syntax here nested functions - this is what I am
attempting to do

countif(a1:a100='open' and b1:b100='i')

JE McGimpsey

One way:

=SUMPRODUCT(--(A1:A100="open"),--(B1:B100="i"))

For an explanation of "--" see
http://www.mcgimpsey.com/excel/doubleneg.html

In article ,
"Bruce" wrote:

I am having trouble with the syntax here nested functions - this is what I am
attempting to do

countif(a1:a100='open' and b1:b100='i')

All times are GMT +1. The time now is 12:14 AM.