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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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')
 
You must log in or register to reply here.

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

Excel Countifs/Sumproduct with mutil Or statement 3
Countif statement using dates 15
How to combine SUMPRODUCT with COUNTIF? 7
how do i count how many times x in column a = 1 or 2 in column b 8
COUNTIF Multiple Values 3
Help in counting and summing cells based on multiple conditions 9
Please help with countif formula 4
Please explain this formula 2

Back
Top