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

B

Bruce

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')
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif statement using dates 15
How to combine SUMPRODUCT with COUNTIF? 6
Help in counting and summing cells based on multiple conditions 9
COUNTIF Multiple Values 3
Please help with countif formula 4
SUMIF with criteria "<>" & "=" 4
how do i count how many times x in column a = 1 or 2 in column b 8
How do I use sumifs - 1

Top